Disable Page Down key

[JillT]

Has anyone got any idea how to disable the Page Down key so a user doesn't go to a new record on a form if they hit it please?

 

[mp9]

Try an Event Procedure in the form's On Key Down event, something like:

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    If (KeyCode = 33 Or KeyCode = 34) And Shift = 0 Then KeyCode = 0
End Sub

Note that 34 traps the PageDown key, and 33 traps the PageUp key, as I'm assuming you also want to catch this.

http://www22.brinkster.com/accessory/

 

[JillT]

Hi mp9. Thanks for that code. However, sorry to say it doesn't work for me, I still go to a blank record if I press page down. I have some workarounds, but it seemed such a simple thing to do!