Uppercase to Tittle Case

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

 

[JL]

Hi Jeannette,

Try function PROPER. That will capitalizes the first letter in each word of
a text string and converts all other letters to lowercase letters.

 

[fredg]

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!

=StrConv([FieldName],3)

THIS WILL BECOME THIS.
This Will Become This.

 

[Dirk Goldgar]

Hi Jeannette,

Try function PROPER. That will capitalizes the first letter in each
word of a text string and converts all other letters to lowercase
letters.

There's no such function native to Access. You may be thinking of the
Excel worksheet function of that name. StrConv() is the function to
use, as Fred posted.