Update contacts using "Select All"

S

Suzan

I've imported all our contacts into Access 2007 (3200 names/addresses/phone
no's, etc.). Is there any way to "select all" and make them "all caps"?
 
D

Douglas J. Steele

You're using a database: get used to database concepts.

You don't "select all": you run an update query along the lines of

UPDATE MyTable
SET MyField = UCase(MyField)
 

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

Similar Threads

Address book compliant with U.S. Postal Service request? 2
Import an outlook contact list into access 2007 0
Important message from Dixons Carphone 1
Query to select individual records 4
How can I customise a contacts list in Outlook? 1
Contact Migration Issue 0
Drop down list and what can be displayed. 2
Outlook 2003 - Change case of Contacts 5

Top