Access, Convert User Input to Uppercase - VBA and VB.Net Tutorials, Education and Programming Services

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 *

More To Explore