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:
Private Sub Form_KeyPress(KeyAscii As Integer) If KeyAscii >= 97 And KeyAscii <= 122 _ Then 'a-z KeyAscii = KeyAscii - 32 End IfEnd Sub