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

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

"Michelle" <Mich...@discussions.microsoft.com> wrote in message
news:600D0EFD-747F-4494...@microsoft.com...
> 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]

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

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

"Michelle" <Mich...@discussions.microsoft.com> wrote in message

news:0895A59F-4ACF-4F5B...@microsoft.com...