correcting capitalizaiton of existing data

[BRC]

I imported data to a table and the data in the original text file was all
capitalized. I would like to convert this data to "proper case" because i
use it for merge functions in mail merge. Does anyone have any idea how I
might do this? I saw on thread on google that mention a "strconv" function
but i don't find any referecne to this in Access Help. using access 2000 and
windows 2000. Thanks for any suggestions.

 

[John Vinson]

I imported data to a table and the data in the original text file was all
capitalized. I would like to convert this data to "proper case" because i
use it for merge functions in mail merge. Does anyone have any idea how I
might do this? I saw on thread on google that mention a "strconv" function
but i don't find any referecne to this in Access Help. using access 2000 and
windows 2000. Thanks for any suggestions.

The Help file (especially in 2000) is a bit quirky. You can get help
for StrConv() but only by opening the VBA editor and searching ITS
help.

In a query, you can update LastName to

StrConv([LastName], 3)

for example. Do follow this up with a manual search for names such as
Mcclure, Macheath, De La Torre, and the like; these should become
McClure, MacHeath, de la Torre, etc. There are VBA codes which handle
this kind of stuff but if the file isn't huge you might want to just
do it manually.

John W. Vinson[MVP]