This article explains how to convert user input to Lowercase 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 lowercase. Change the format to:

<@


Result:

Forms:

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

<@

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

After:

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

• Lowercase.Zip

See also:

• Access, Add Leading Zeros Custom Number Formats
• Access, Convert User Input to Uppercase
• Access, Fixed Decimal Places Number Format
• Access Field Properties Locked
• Access Check If Field is Null, Conditional Macro
• First Letter Uppercase Only Access Tables
• First Letter Uppercase Only Access Form
• The Ucase Function

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