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:
Select the field you would like its values to be converted to uppercase. Change the format to:
>@
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:
>@
In result, all user input in the controls with this format will be converted to uppercase:
After:
You can download the sample file used in this article from the link below:
See also:
- Access, Add Leading Zeros Custom Number Formats
- Access, Fixed Decimal Places Number Format
- Access, Convert User Input to Lowercase
- Access Field Properties Locked
- Access Check If Field is Null, Conditional Macro
- First Letter Uppercase Only Access Tables
- First Letter Uppercase Only Access Form
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