Last Word in Field

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

How can I always display the last word in a field?

I have a field that contains a value of several words
(i.e. 1 - Van Joe, or 2 - Van Phil). I want to display
only the last word, which can vary in length.

Thanks in advance.

Stephen
 
Try the following expression in the Control Source property of a textbox:

=Mid([MyField], InStrRev([MyField], " ") +1)


hth,
 
Back
Top