Update contacts using "Select All"

  • Thread starter Thread starter Suzan
  • Start date Start date
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"?
 
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)
 
Back
Top