Upper Case

  • Thread starter Thread starter Chris Savedge
  • Start date Start date
C

Chris Savedge

Our data entry person has enter all of our contacts into an access table
using all upper case letters.......Is there anyway I can change all of those
names back to the proper form..........meaning can I keep the first letter
upper case and the rest lower case?

Thanks
Chris
 
You could run an update query using the StrConv function and its option to
convert to "proper case"...

UPDATE Tablename
SET Fieldname = StrConv([FieldName], 3);

Note that this won't properly handle names with mid-text uppercase letters,
such as MacDonald -- they'll be changed to Macdonald.
 
Yes, but there may be some manual checking and correction required afterward
....

UPDATE tblTest SET tblTest.Text1 = StrConv([Text1],3);

The manual checking and correction arrises because StrConv doesn't always
get personal names right (or names of places, products etc. named after
persons).

? strconv("MCDONALD",vbProperCase)
Mcdonald
? strconv("O'BRIEN",vbProperCase)
O'brien

BTW: vbProperCase is an intrinsic constant, with the numerical value 3. In
VBA code, you can use the constant, as in the second and third examples
above, but in queries, you need to use the numerical value, as in the first
example above.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top