By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,638 Members | 2,204 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,638 IT Pros & Developers. It's quick & easy.

PgUp and PgDown

P: n/a
Hi All,

How Can I disable PgUp and PgDown keys while in the Form view? Is
there is any way to do this using GUI (no scripts) in Access 07?

Matuag.

May 18 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"Matuag" <ma****@gmail.comwrote in message
news:11*********************@p77g2000hsh.googlegro ups.com...
Hi All,

How Can I disable PgUp and PgDown keys while in the Form view? Is
there is any way to do this using GUI (no scripts) in Access 07?

Matuag.
Set the form filter or query to select only 1 record.
May 18 '07 #2

P: n/a
In Design View, goto Form -- Properties -- Events and set Key Preview to YES

Then in code:

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case 33, 34 ' '33 - PgUp; 34 - PgDown
KeyCode = 0
End Select
End Sub

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

May 19 '07 #3

P: n/a
Many Thanks.

May 20 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.