ACC2: How to Disable PAGE UP and PAGE DOWN Keys in a Form

• Microsoft Access version 2.0

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

This article describes the following two methods that you can use to disable the PAGE UP and PAGE DOWN keys in a form:

• Open the form as a Dialog form using the OpenForm macro action.

  -or-

• Trap the PAGE UP and PAGE DOWN keys in the KeyDown event.

MORE INFORMATION

Method 1: Opening the Form as Dialog Using the OpenForm Macro Action

The PAGE UP and PAGE DOWN keys will be inoperative in a form if the form is opened using an OpenForm macro action with the Window Mode argument set to Dialog. To demonstrate this technique, create and run a new macro with the following actions in the sample database NWIND.MDB.

   OpenForm
      Form Name: Customers
      Filter Name: <leave empty>
      Where Condition: <leave empty>
      View: Form
      Data Mode: Edit
      Window Mode: Dialog

NOTE: The Microsoft Access Wizards use this technique to limit navigation in multiple-page forms.

Method 2: Trapping PAGE UP and PAGE DOWN in the KeyDown Event

The PAGE UP and PAGE DOWN keys can be detected and trapped in a control by adding the following lines of Access Basic code to the KeyDown event for all the controls on a form where the PAGE UP and PAGE DOWN keys should be disabled:

   If KeyCode = KEY_PRIOR Or KeyCode = KEY_NEXT Then
      KeyCode = 0
   End If

The following example demonstrates how to detect and trap the PAGE UP and PAGE DOWN keys in a control's KeyDown event.

CAUTION: Following the steps in this example will modify the sample database NWIND.MDB. You may want to back up the NWIND.MDB file, or perform these steps on a copy of the NWIND database.

1. Open the Customers form in Design view.

2. Create an event procedure with the following code for the KeyDown event for each control on the form:

         If KeyCode = KEY_PRIOR Or KeyCode = KEY_NEXT Then
            KeyCode = 0
         End If
   
      NOTE: To create each event procedure, select a control, click the Build
      button to the right of the OnKeyDown property, and then select Code
      Builder.
   
      For example, the event procedure code for the Customer ID field will
      look as follows:
   
         Sub Customer_ID_KeyDown (KeyCode As Integer, Shift As Integer)
            If KeyCode = KEY_PRIOR Or KeyCode = KEY_NEXT Then
               KeyCode = 0
            End If
         End Sub
   
   

3. Close the module and then switch the form to Form view.

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

REFERENCES

For more information about disabling PAGE UP and PAGE DOWN in Microsoft Access 95 and 97, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q132031
   TITLE     : ACC: How to Disable PAGE UP and PAGE DOWN Keys in a Form
               (95/97)

For more information about the KeyDown event, search for "KeyDown," and then "KeyDown, KeyUp Events" using the Microsoft Access Help menu.