Separating a full name text field into First Name & Last Name

[Guest]

Hello All

I want to set up my data base to have two separate text boxes called
FirstName & LastName. Currently I have only one text field called
CustomerName.

I want to chnage the setup because I want to be able to list the customer
names in a list box in alphabetical order, using the customers surname.

Is there an easy way to separate the data in the CustomerName Text box to
populate the FirstName & LastName Text boxes, or do I have to manually change
the names???

 

[Rick B]

Do a search. This is asked almost once a week.

Go to www.google.com, click on the "groups" link. Type in a search string
like the following:

microsoft.public.access separate names
microsoft.public.access first last names separate

In short, you can do it, but there are lots of names that you will have to
go back and clean up. For example, how would you break apart "Mary Alice
Smith"? Would you use the first space, or the second? Before you answer,
what about "Mark Jones Jr."? Or "Susan de la Rosa"?