ACC: Disable PAGE UP and PAGE DOWN Keys in a Form (95/97)

MORE INFORMATION

To disable the PAGE UP and PAGE DOWN keys in a form, follow these steps:

1. Open any database, open any form in Design view, and set the form's properties as follows:
   

         KeyPreview: Yes
         OnKeyDown: [Event Procedure]
   						

2. Click the Build button to the right of the OnKeyDown property and type the following procedure:
   

         Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
            Select Case KeyCode
               Case 33, 34
                  KeyCode = 0
            End Select
         End Sub
   						

   
   NOTE: KeyCodes 33 (&H21) and 34 (&H34) represent PAGE UP and PAGE DOWN, respectively. You can disable other keys on the form by including the appropriate KeyCode in the Case statement. For example, if you also want to disable the ESC key on the form, add KeyCode 27 to the Case statement as follows:
   

         Case 27, 33, 34
   						

3. Open the form in Form view and notice that the PAGE UP and PAGE DOWN keys have no effect.

REFERENCES:

For more information about the KeyPreview property, search for "KeyPreview property," using the Microsoft Access 97 Help Index.