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.
