ACC: Validation Rule to Require Uppercase Letters in a Field

 Last reviewed: April 2, 1997
Article ID: Q100469
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

Microsoft Access does not have a setting to force entries in a field or control to be in uppercase letters; however, you can use a validation rule to ensure that only uppercase letters are used.

The following sample validation rule requires that entries in a field or control called Last Name be entered in uppercase letters: 

   StrComp(UCase([Last Name]),[Last Name],0) = 0
In Microsoft Access version 2.0 and later, you have two additional alternatives: an input mask, or an event procedure triggered by the KeyPress event. The following input mask will accept either letters or numbers and will make the first letter uppercase and the following three lower case: 

   >C<CCC
Follow these steps to change letters to uppercase as you type them in a control in a form:

  1. Open the form in Design view.

  2. Set the control's OnKeyPress property to the following event procedure: 

          Sub Field0_KeyPress (KeyAscii As Integer)
         KeyAscii = Asc(UCase(Chr(KeyAscii)))
      End Sub

REFERENCES

For more information about input masks, search the Help Index for "InputMask property," or ask the Microsoft Access 97 Office Assistant.

For more information about validation rules, search the Help Index for "ValidationRule property," or ask the Microsoft Access 97 Office Assistant.

For more information about OnKeyPress, search the Help Index for "OnKeyPress property," or ask the Microsoft Access 97 Office Assistant.

Additional query words: capital letter upper case all
Keywords : GnlValid kbusage
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbinfo

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 2, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.