Change text from lower case to upper case in Access 2007

G

Gloria

How do I put an indicator in a field so that if text is entered in lower case
it will automatically change to upper case.

Thank you.
 
J

John W. Vinson

How do I put an indicator in a field so that if text is entered in lower case
it will automatically change to upper case.

Thank you.

There's no "indicator" to do so. You can set the Format property of a form or
report control to

Just the single right-corner-bracket character, to *display* the contents in
upper case regardless of how they're stored;

or you can run an update query updating the field to

UCase([fieldname])

to update existing data;

or you can put some VBA code in the AfterUpdate event of the textbox on a Form
to convert the data to upper case.
 

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

Top