How to convert existing text to proper case

S

Shub

I created a new table by importing the data. The text in some of the fields
are either in upper case or lower case. How do I convert the existing text to
proper case?
 
A

Al Camp

Shub,
Use the StrConv function. It converts the first letter of every word in a string to
uppercase.
StrConv(string, vbProperCase)

Be aware that strings like macarthur will yield Macarthur... not MacArthur.
MCADAMS yields Mcadams... etc..
 
D

Duane Hookom

If you are doing this conversion in a query, you need to replace
vbProperCase with 3.
StrConv(string, 3)
 
Top