How to convert existing text to proper case

[Guest]

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?

 

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

 

[Duane Hookom]

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