Copy text before space? [First Name from Full Name] 2

[Maillme]

Hi There,

I have a text box on a form which includes the full name of a person - I would like to ba able to take the first name (any text before a space) and copy this into another field - but im not sure how?
Any help would be appreciated,

many thanks,
Neil

 

[PHV]

A starting point:

Me![another field] = Split(Me![text box] & " ")(0)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya Maillme . . .

Have a look at the [blue]InStr function![/blue]

A starting point:

[blue]Public Function GetNam1(Nam As String)
   Dim idx As Integer
   
   idx = InStr(1, Nam, " ")
   If idx > 0 Then GetNam1 = Left(Nam, idx - 1)

End Function[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Maillme]

thanks