Change text from lower case to upper case in Access 2007

[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.

 

[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.