Uppercase to Tittle 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!
 
J

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

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!
Click to expand...

=StrConv([FieldName],3)

THIS WILL BECOME THIS.
This Will Become This.
 
D

Dirk Goldgar

JL said:
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.
Click to expand...

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