Access Tip - Automatically Convert Text Fields to Uppercase

To automatically convert the text in a field to uppercase, no matter how someone enters the data, set the Format property to >.

Select the table from the list of tables in your database.

On the list of tables in your Access database, select the table. Click Design View. Move your cursor to the field you are formatting (the field has to be a text field). In the Field Properties section of your screen (bottom half of screen), make sure the General tab is selected.

Type > next to Format, as shown below.



For additional information: Access Database Design Bootcamp