Splitting Hairs (Or Strings)

[Dannybe2]

To save time, I would have a name function which I have combined the firstname and lastname as follows:

=FirstName & " " & LastName

When a user selects a name based on this, I want to then split it back into FirstName and LastName fields again to prevent the user having to enter in two fields instead of one. How do I split it?

 

[BoxHead]

To split the string...

strName = FirstName & " " & LastName

FirstName would be

   Left(strName,instr(strName," ") - 1)

LastName would be

   Mid(strName,instr(strName," ") + 1)

However, you have to watch out for people with two first names that would contain a space. The Left and Mid statements offered will return everything to the left of the first space in the string and everything after the first space in the string, respectively.

I would think that if the names are indexed, it wouldn't be an issue. Where are you using the expression that puts them together? A query? form? report?


John

Use what you have,
Learn what you can,
Create what you need.

 

[GingerR]

i agree--are the names held in a table? then you can just pull them from the table based on the index of the 'combined' name that the users chooses.