Originally posted by MichèleW
Is there a function that will retrieve the last 'word' typed in a field.
"My name is Anna" = "Anna"
"My father's age is 56" = "56"
The function 'rightwords' doesn't seem to exist in Access. I use Access 2000 and the InStrRev isn't recognized.
Thankyou for reading and eventually answering my question.
There is no such function in ACCESS but you can build it, usning the instr in a loop searching the space you could optain the position of the last space, then using the Mid Function you could get the last word in the string.