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


M

Michelle

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?
 
G

Graham R Seach

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
 
Ad

Advertisements

M

Michelle

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

Graham R Seach

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

Advertisements

Joined
Dec 14, 2016
Messages
1
Reaction score
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)
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top