Modifying names

[Harvard]

Hey guys,

I have a table with 3 fields: first name, last name and email. Some people
enter their name in all caps, or in all lowercase. Is there a way to create
a query that manipulates the first letter in first name to force it to be
uppercase, and the rest of the letters in the name to be lowercase?

Thanks

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), David McAfee has a small Access
database sample called "Proper Case Function" which illustrates how to do
this. You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=166

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L