Combo Box

[SD23]

I have a combo box which has a list of names. The last names are all capatalized, while the first names are lower cased. I was wondering in the Row Source code under properties if it was possible to just take the capatlized letters. Is there a code for that?

Example

SMITH, john

I want the combo box to just take the cap letters so it only takes SMITH.

Thank you for your help. I really appreciate it

 

[mhartman]

Hello:

A question first: Is this name in one column or two columns in your table, with the first name being in one column and the last name being in another?
'
Because if it is, the name should be in separate fields in your table and joined by an Sql statement in the combo box
'
Regards
Mark

 

[ghudson]

Search around the forum for there are plenty of examples on how to parse your data.

 

[SD23]

The first and last name are in the same column. The last name is capitalized while the first name is in lower case. Thank you