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

 

[MGFoster]

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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the StrConv() function:

UPDATE table_name
SET first_name = StrConv(first_name, vbProperCase),
last_name = StrConv(last_name, vbProperCase),
email = StrConv(email, vbProperCase)

If it doesn't recognize the vbProperCase, substitute the number 3 for
the word vbProperCase.

HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **


-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSgpK2IechKqOuFEgEQJg+QCgpuhwAStTGi7bSH9uYdZrD8kIsK4An3LM
ya1ZQOq2BU3PRaTqyKtXCrN/
=qSZG
-----END PGP SIGNATURE-----