How to change small letters into capital letters?

[Blinda]

Hi All,

I have some one do the data entry for me, but all the text information was
entered in small letters. Can anyone help to find a way for me to change them
into capital? Thank you,

Blinda

 

[Michael H]

Blinda,

The UCase function will convert a string into all upper case, if that is
what you want.

If instead you are talking about Proper Case, that's a bit more complicated.
There is an excellent Proper Case function sample at Roger's Access Library:
http://www.rogersaccesslibrary.com
Look in "Other Developer Libraries" under McAfee, David.

-Michael

 

[jleckrone]

Create an update query and chose the column in the table you want to
change. In the Update To row type Format([YourColumnName], ">"). Run
the query and your text will be all caps.

 

[Blinda]

Thanks. It works perfectly.

 

[Blinda]

Hi Michael,

Thank you so much. Could you please tell me how/where to use this function?
Tks,

Blinda