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

    Graham R Seach
    Microsoft Access MVP
    Sydney, Australia
    Graham R Seach, Jun 1, 2005
    1. Advertisements

  3. Michelle

    Michelle Guest

    How do I create this query? What does the "3" in "StrConv(myField, 3)" mean?
    Thanks for the prompt reply!
    Michelle, Jun 1, 2005
  4. 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.

    Graham R Seach
    Microsoft Access MVP
    Sydney, Australia
    Graham R Seach, Jun 2, 2005
  5. Michelle


    Dec 14, 2016
    Likes Received:
    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
    Becky likes this.
    1. Advertisements

Ask a Question

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.