Uppercase to Title Case

J

Jeannette

Does anyone know how to change uppercase data that was
imported into Access to title case? I know how to
convert uppercase to lowercase and lowercase to
uppercase. Any input would help!
 
K

Ken Snell [MVP]

There is the StrConv function that has the ability to change to "proper
case", though that means capitalize the first letter of each word and make
all other letters in that word small (not always what you want).

You use it by
StrConv([FieldName], 3)
 
Top