How to change small letters into capital letters?

Hi All,

I have some one do the data entry for me, but all the text information was
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9559-how-change-small-letters-into-capital.html
entered in small letters. Can anyone help to find a way for me to change them
into capital? Thank you,

Blinda

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Blinda,

The UCase function will convert a string into all upper case, if that is
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9559
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:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9559
http://www.rogersaccesslibrary.com
Look in "Other Developer Libraries" under McAfee, David.

-Michael



"Blinda" wrote:

> 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

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9559

Thanks. It works perfectly.

"jleckrone@hotmail.com" wrote:

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

Hi Michael,

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

Blinda

"Michael H" wrote:

> 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.
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9559
> -Michael
>
>
>
> "Blinda" wrote:
>
> > 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9559
> > into capital? Thank you,
> >
> > Blinda