How to Convert Data to Uppercase in Access

by Lysis

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.

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.

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.

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.

4

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

5

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

Items you will need

About the Author

Lysis is the pen name for a former computer programmer and network administrator who now studies biochemistry and biology while ghostwriting for clients. She currently studies health, medicine and autoimmune disorders. Lysis is currently pursuing a Ph.D. in genetic engineering.

More Articles

Photo Credits