format number within text string (1 Viewer)

[Davros]

hi
I'm no expert and can't seem to find what i'm looking for.

i have data i enter into a text box. the data might be in the format

"name"
OR
"name, date, age"
OR
"name, date"

if on the second or third example above i entered the data like shown below how would i VB code the afterupdate to do this:

turn
David Roberts, 12122006
to
David Roberts, 12/12/2006

OR turn
David Roberts, 12122006, 56
to
David Roberts, 12/12/2006, aged 56

any ideas??
I'm working along the lines of instr, mid, etc. but i'm not sure of the correct procedure
thanks in advance

 

[Johny]

Why not entering each data in a separate textfield?
1 for name (restrict to only textinput)
1 for date (set the inputmask to 'short date')
1 for age (restrict to only numerical input and max 99?)

 

[gemma-the-husky]

you ought to have three separate boxes for three distinct fields

having done this, just set the format or input mask for each of the boxes to achieve what you require.

eg with a number, set the mask as
"Aged "###

this will allow you to input a 3 figure number max, stored as the number, but displayed as eg Aged 56

look in help at inputmask and format

 

[Davros]

thanks for replying
this text box in my record serves no data purpose whatsoever except for me to see that i have correctly matched a photograph to the actual record.
all the information in this text box is contained elsewhere in seperate fields.
this is not actually a problem but seeing that i have thousands of records to create it would save me some time.
the orignal problem still stands.
how would i go about solving it?

 

[boblarson]

If you are storing the items in other fields, don't try to add that field, just display a text box that concatenates from the other fields for your display purposes.

Also, you wouldn't use the AfterUpdate event to change the input anyway. You would use the BeforeUpdate, otherwise you could end up in a perpetual loop. The AfterUpdate of a control should NEVER be used to revise data in that control that has just been saved.

 

[Davros]

the original problem still stands.
boblarson - you are reading the question backwards. i do not need the data to identify the photograph even though the data is correctley stored in another table. i need the data that i collect in the 'field' to confirm that i have matched the correct photograph. the data in the 'field' does not nessasaraly match the data i have in my database.
this question is about saving time entering the data NOT about entering it correctly. i have entered it correctly in another table. when i match the tables up with the data i have collected in the 'field' it might or might not match - i cannot tell untill i have looked at the photograph AND the table that contains the book data. BUT the right photograph must be matched up to the record hence the text box with an inscription in it that might or might not have
name, date of birth, date of death, age
so the original question still stands.
I repeat - i have entered the data correctly but not in the table that i use for storing information that i have collected from the 'field'