Disabling Page Up and down 3

[scrano]

Can anyone please help me and tell me how to disable the Page Up and Page Down keys. Please. Thanks in advance.

 

[RickSpr]

I doubt you want to globally disable these keys throughout Access. If you want to disable them for a specific form, set the form's Key Preview property to Yes, and then add the following code in the KeyDown event procedure:

    If (KeyCode = vbKeyPageUp) Or (KeyCode = vbKeyPageDown) Then
        KeyCode = 0
    End If

Rick Sprague

 

[scrano]

Thanks Rick, worked a treat

 

[wtstro]

Thanks Rick. Had the right code, missed the Key Preview property.

Bill