General discussion

Locked

Microsoft Access Case Conversion

By tangman41 ·
I have an Access database I use for address labels. I want to convert the data to ALL CAPS WITHOUT having to retype it. Does anyone know how to "convert case"?

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Microsoft Access Case Conversion

by Bill_H In reply to Microsoft Access Case Con ...

Sure...run an update query using the UCASE$ function for the fields you wish to convert to upper case. For example:

UPDATE mytable SET field1=UCASE$(field1), field2=UCASE$(field2);

Hope this helps...

Collapse -

Microsoft Access Case Conversion

by tangman41 In reply to Microsoft Access Case Con ...

Poster rated this answer

Collapse -

Microsoft Access Case Conversion

by mrmolio In reply to Microsoft Access Case Con ...

You could also simply open the table in Design View and set each of the fields' Format property to ">" (without the quotes).

Collapse -

Microsoft Access Case Conversion

by tangman41 In reply to Microsoft Access Case Con ...

Poster rated this answer

Collapse -

Microsoft Access Case Conversion

by parier In reply to Microsoft Access Case Con ...

In the report, this is a report right? Go to teach fields properties and find the field for format and type ">" without the quotes, that means all caps.

You can also assign every first letter or every work caps, like this

John Smith
10 StartAvenue
New York, NY 10445

Collapse -

Microsoft Access Case Conversion

by tangman41 In reply to Microsoft Access Case Con ...

Poster rated this answer

Collapse -

Microsoft Access Case Conversion

by tangman41 In reply to Microsoft Access Case Con ...

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums