How to Convert Data to Uppercase in Access

By Lysis

i Siri Stafford/Digital Vision/Getty Images

When running a Microsoft Access report, formatting the text in the Access query is quicker than formatting it using front-side code. Access allows you to return string results with all uppercase letters using the Design View for your tables. The character used in the format properties window is the ">" sign. This character tells Access to use uppercase for all the results in an indicated column.

Step 1

Double-click the file that contains the table you want to edit. When Access opens, click the "Tables" button in the main window. This gives you a list of all the tables programmed in Access.

Step 2

Right-click the table you want to edit and select "Design View." This opens the Design Viewer where you can make modifications to your table's format.

Step 3

Click the table column that contains the information you want to return in uppercase lettering. When the properties are displayed, click the "General" tab.

Step 4

Enter ">" into the property labeled "Format." Click the "Save" button to save your table changes. You are returned to the main Access menu.

Step 5

Double-click the table to view the information and test your changes.