Uppercase to Title Case

  • Thread starter Thread starter Jeannette
  • Start date Start date
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!
 
I use this code:
myWord = StrConv(myWord, vbProperCase)

However, MACDONALD becomes Macdonald so you may consider a table of
exceptions that contains prefixes, eg Mac, and other exceptions such as names
eg MacDonald. My version changed macerator into MacErator so have fun.
 
Back
Top