Private Sub Form_KeyPress(KeyAscii As Integer)
If KeyAscii >= 97 And KeyAscii <= 122 Then 'a-z KeyAscii = KeyAscii - 32 End If End Sub If you set a form's KeyPreview property to True, all keystrokes for items on that form first trigger the form's events. This makes it easy to do form-level filtering and keystroke trapping. For example, if you want to make all text boxes on a form force uppercase entry, you can do it with three lines of executable code: |