Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

How to change small letters into capital letters?

Discussion in 'Information Technology' started by Blinda, Jul 28, 2006.

  1. Blinda

    Blinda
    Expand Collapse
    Guest

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


  3. Michael H

    Michael H
    Expand Collapse
    Guest

    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



    "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
     
  4. jleckrone@hotmail.com

    jleckrone@hotmail.com
    Expand Collapse
    Guest

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

    Blinda
    Expand Collapse
    Guest

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

    Blinda
    Expand Collapse
    Guest

    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.
    >
    > -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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page