How to convert existing text to proper case

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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..
 
If you are doing this conversion in a query, you need to replace
vbProperCase with 3.
StrConv(string, 3)
 
Back
Top