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,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying only the FIRST TWO WORDS of a field 1
2003 format text bold & normal in one field 1
Sort text field by 2nd word 2
PowerPoint Powerpoint Slow Animations 2
Word Lock specific drop downs on a Word Document 0
Split column contents (de-concantenate) 7
Controlling field width? 2
Find data in a string and string the data 2

Back
Top