Access, Convert User Input to Uppercase

This article explains how to convert user input to uppercase in Access. This applies to user input in Tables and Forms.


Tables:

Open the table in design view:
Table

Select the field you would like its values to be converted to uppercase. Change the format to:

>@

Format Uppercase

Result:
Result


Forms:

Open the form in design view. Select the controls where their values must be converted to uppercase. In the property sheet change the format to:

>@

Form

In result, all user input in the controls with this format will be converted to uppercase:
Before
After:
After

You can download the sample file used in this article from the link below:

See also:

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com

Leave a Reply

Your email address will not be published. Required fields are marked *

privacy policy