R
Ron
I've seen several related posts but haven't found one that quite achieves
what I'm trying to do:
I have a table with one memo field: [FiledData]. The memo field contains a
whole bunch of data of various lengths, but the one consistent piece of data
is a number in the following format:
##########-##-######
It usually appears in the middle of the field, never at the beginning and
only sometimes at the end, so I guess the Mid() function will be used.
I would like to find that data in the memo field, extract it and place it in
a separate field: [AccessionNumber]. I would like this to happen on the
"After Update" event of the [FiledData] field in a form.
Any help in this matter is greatly appreciated!
what I'm trying to do:
I have a table with one memo field: [FiledData]. The memo field contains a
whole bunch of data of various lengths, but the one consistent piece of data
is a number in the following format:
##########-##-######
It usually appears in the middle of the field, never at the beginning and
only sometimes at the end, so I guess the Mid() function will be used.
I would like to find that data in the memo field, extract it and place it in
a separate field: [AccessionNumber]. I would like this to happen on the
"After Update" event of the [FiledData] field in a form.
Any help in this matter is greatly appreciated!