Rich (or anyone who can help) Page Up Page Down Function

[chablups]

Rich, thanks. I went to the link you suggested and was able to disable my page up page down keys, but it also disabled by tab key and alt key which I don't want to do. Is there any way you (or anyone out there) knows of to just disable the Page Up Page Down keys, or better yet to just stop Page Up & Page Down from going to the next form when you get to the end of the form?

Also, thanks Rich. At the link you provided I was also able to find the answer to an even more pressing question: How to disable the autosave feature so that I am prompted to save when I leave a form. This way if I or more than likely, my wife, makes a change she is not aware of on a form, it won't accidentally be saved. Personally, I don't like the auto save feature for date entry.

 

[Keith P]

You could try the form's cycle property.

To disable page up and down I use the form's keydown event and check for the keycode. I think they are 126 and 127, or may be 33, 34.

Hope this helps.

 

[Keith P]

Having now seen Rich's original response, I use the same approach. Change the code from
Case 33, 34, 9, 18
to
Case 33, 34