Length to first space in field

[JAguirre]

I have a field that contains both a first and last name. I need to break
this information into two fields - a first name field, and a last name field.
Is there a statement I can use to find the first space in a field? Any help
is greatly appreciated

 

[Douglas J. Steele]

Steve's given you an answer to your question about how to do you find the
first space in a field, but are you sure that's what you need? What about a
name like gymnast Mary Lou Retton? Are you going to have her last name as
Lou Retton?

 

[JAguirre]

I actually thought of that and have verified that in this particular data set
there are no names like that. Well ... there were two that have been
modified.

I'll try Steve's code and see if that works.

 

[JAguirre]

Perfect. Thank you!!

Me!FirstName = Left(Me!FullName, Instr(Me!FullName," ")-1)

Steve