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.