ACC: Validation Rule to Require Uppercase Letters in a Field (100469)

SUMMARY

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