How to Find the Position of a Space in a Name

Stever · Jan 20, 2006

What's the best way to identify the position of the space in a name. For
example, "Bob Jones" would be position 4. Would IIF work?

Roger Carlson · Jan 20, 2006

Actually, InStr would work.

dim pos as integer
pos = InStr("Bob Jones", " ")

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L