Find space location in a text string

[Cmacvp16]

What function in Access is equivalent to the Find function in excel? I need to identify the position of the first space in a text string.

ex. North Florida Office ( Answer 6, the space location between North and Florida)

Or

How can I simply pull the first word in a text string in a Report control?

Thanks

 

[IMO]

Create an Unbound text box on your report and enter this into the Control Source:

=Left([YourField],InStr([YourField]," "))

Changing "YourField" to the name of the field in the table which contains the text

IMO

 

[Cmacvp16]

Thanks!!!