Can you change text case (uppercase/lowercase) in Access like in W

Discussion in 'Access General' started by Michelle, Jun 1, 2005.

  1. Michelle

    Michelle Guest

    All of my records had been originally entered in uppercase text. I've found
    that the data is hard to read in all caps and I would like to change it to
    upper and lowercase letters. Is there a tool available to change the case of
    the text like in Microsoft Word?
     
    Michelle, Jun 1, 2005
    #1
    1. Advertisements

  2. Michelle,

    You can use a function called StrConv().

    Create a query like so:
    UPDATE tblMyTable
    SET MyField = StrConv(myField, 3)

    ....of course, change tblMyTable to reflect the table you're using, and
    myField to the name of the field you want to change.

    Regards,
    Graham R Seach
    Microsoft Access MVP
    Sydney, Australia
    ---------------------------

    "Michelle" <> wrote in message
    news:...
    > All of my records had been originally entered in uppercase text. I've
    > found
    > that the data is hard to read in all caps and I would like to change it to
    > upper and lowercase letters. Is there a tool available to change the case
    > of
    > the text like in Microsoft Word?
     
    Graham R Seach, Jun 1, 2005
    #2
    1. Advertisements

  3. Michelle

    Michelle Guest

    Re: Can you change text case (uppercase/lowercase) in Access like

    How do I create this query? What does the "3" in "StrConv(myField, 3)" mean?
    Thanks for the prompt reply!

    "Graham R Seach" wrote:

    > Michelle,
    >
    > You can use a function called StrConv().
    >
    > Create a query like so:
    > UPDATE tblMyTable
    > SET MyField = StrConv(myField, 3)
    >
    > ....of course, change tblMyTable to reflect the table you're using, and
    > myField to the name of the field you want to change.
    >
    > Regards,
    > Graham R Seach
    > Microsoft Access MVP
    > Sydney, Australia
    > ---------------------------
    >
    > "Michelle" <> wrote in message
    > news:...
    > > All of my records had been originally entered in uppercase text. I've
    > > found
    > > that the data is hard to read in all caps and I would like to change it to
    > > upper and lowercase letters. Is there a tool available to change the case
    > > of
    > > the text like in Microsoft Word?

    >
    >
    >
     
    Michelle, Jun 1, 2005
    #3
  4. Re: Can you change text case (uppercase/lowercase) in Access like

    Michelle,

    To create a query:

    1. From the Database Window, select the Queries tab.
    2. Click New. The New Query dialog is displayed.
    3. Select Design View, then click OK.
    4. Double-click the table containing the field you want to change.
    5. Click Close.
    6. Double-click the Primary Key.
    7. Double-click the field you want to change.
    8. If there are any criteria that need to be specified in order to uniquely
    identify the specific record to change, double-click them.
    9. From the Query menu, select Update Query.
    10. For the field you want to change, enter the following in the row marked
    Update To:
    StrConv(myField, 3)
    ...where myField is the name of the field you're changing.
    11. In the Criteria row for each of the fields selected in Step 8, enter a
    value to filter on.
    12. Similarly, if you need to filter the field you're changing, enter a
    value for its Criteria.
    13. From the File menu, select Save.
    14. Give it a name, and click OK.
    15. Close the query.
    16. From the Database Window, double-click the new query to run it.

    The 3 in StrConv(myField, 3) instructs the function to change the specified
    text to Proper Case.

    Regards,
    Graham R Seach
    Microsoft Access MVP
    Sydney, Australia
    ---------------------------

    "Michelle" <> wrote in message
    news:...
    > How do I create this query? What does the "3" in "StrConv(myField, 3)"
    > mean?
    > Thanks for the prompt reply!
    >
    > "Graham R Seach" wrote:
    >
    >> Michelle,
    >>
    >> You can use a function called StrConv().
    >>
    >> Create a query like so:
    >> UPDATE tblMyTable
    >> SET MyField = StrConv(myField, 3)
    >>
    >> ....of course, change tblMyTable to reflect the table you're using, and
    >> myField to the name of the field you want to change.
    >>
    >> Regards,
    >> Graham R Seach
    >> Microsoft Access MVP
    >> Sydney, Australia
    >> ---------------------------
    >>
    >> "Michelle" <> wrote in message
    >> news:...
    >> > All of my records had been originally entered in uppercase text. I've
    >> > found
    >> > that the data is hard to read in all caps and I would like to change it
    >> > to
    >> > upper and lowercase letters. Is there a tool available to change the
    >> > case
    >> > of
    >> > the text like in Microsoft Word?

    >>
    >>
    >>
     
    Graham R Seach, Jun 2, 2005
    #4
  5. Michelle

    bluz1st

    Joined:
    Dec 14, 2016
    Messages:
    1
    Likes Received:
    1
    To anyone who stumbles on this post........I think the syntax Graham is using here is wrong..........try it this way: StrConv([fname],3)
     
    bluz1st, Dec 14, 2016
    #5
    Becky likes this.
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Vinayaka B
    Replies:
    1
    Views:
    282
    Tom Wickerath
    Oct 3, 2004
  2. wordsmithbb

    How do I change uppercase to lowercase in Word?

    wordsmithbb, Nov 4, 2004, in forum: Access General
    Replies:
    2
    Views:
    153
    Joan Wild
    Nov 5, 2004
  3. Jeannette

    Uppercase to Title Case

    Jeannette, Nov 18, 2004, in forum: Access General
    Replies:
    1
    Views:
    93
    Ken Snell [MVP]
    Nov 18, 2004
  4. Roger Bell

    Changing UPPERCASE to Sentence Case

    Roger Bell, Nov 19, 2004, in forum: Access General
    Replies:
    5
    Views:
    179
    fredg
    Nov 19, 2004
  5. Eric

    convert uppercase to lower case function?

    Eric, Jan 4, 2005, in forum: Access General
    Replies:
    3
    Views:
    140
    Douglas J. Steele
    Jan 4, 2005
  6. PJCPA
    Replies:
    1
    Views:
    129
    KARL DEWEY
    Oct 20, 2006
  7. Becky
    Replies:
    3
    Views:
    151
    Daniel
    Apr 5, 2007
  8. Gloria
    Replies:
    1
    Views:
    133
    John W. Vinson
    Dec 30, 2008
Loading...