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)
 
Top