Change case

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.
 
W

Wayne Morgan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

format question 5
upper case lower case 0
Re-Formatting Existing Data 2
Upper Case letters 3
Lower-Case Characters 2
Title Case 10
Capitalisation of First Letter in Name 4
Upper case to Lower case 5

Top