I have a form with a pull down box which has a list of about 50 names. The last names are capatilized and the first names have the first letter capitalized and the rest lower case. For example,
SMITH, John
DOE, Sam
The user can input their own name if it is not included in the pull down menu. I was wondering if there is a way for the database to put the users name in the same format. For example
If the user enters: smith, john
The database through some code will change it to: SMITH, John
I would appreciate some help. I am pretty new at VB. Thank you.
SMITH, John
DOE, Sam
The user can input their own name if it is not included in the pull down menu. I was wondering if there is a way for the database to put the users name in the same format. For example
If the user enters: smith, john
The database through some code will change it to: SMITH, John
I would appreciate some help. I am pretty new at VB. Thank you.