Change case

  • Thread starter Thread starter Murray
  • Start date Start date
M

Murray

Hi, i have a DB with surnames names and first names in
that order. They are the 2nd and 3rd column respectively.
Some of the names are in all upper case and some in lower
case except for the first letter. Is there any way in
access to chage them all to lower case except the first
letter. I exported them to .rtf file and used words change
case option, but then couldn't import the data back.

Thanks in Advance
Murray.
 
I tried this with an update query and it appears to work.

UPDATE tblMyTable SET tblMyTable.MyField = StrConv([MyField],3);

The constant for 3 is vbProperCase, but the constant doesn't appear to work in the query.
 
Back
Top