View Full Version : Disabling the Escape Key


Chris Pollock
06-16-2000, 04:38 AM
I have a Access 97 application that displays a form that contains a auto-number. I'm having problems with employees hitting the escape key. When this happens, the auto number is cleared and lost. What I want to do is to disable the Escape key when I open the form and then enable it when I close the form. I have no idea how to do this. Can anyone help me?

Talismanic
06-16-2000, 08:04 AM
Why not just lock the record? You just go to the field in design view select properties and look for the data tab. Change Locked to yes and the user will not be able to alter the value in the field.

Chris Pollock
06-16-2000, 09:54 AM
Thanks for the response. I tried what you suggested but it didn't work. I currently have the form properties "Allow Deletions" and "Allow Edits" set to NO, I also set the "locked properties" to YES as you suggested. When the escape key is pressed it still clears all the data from the form. Once the auto number is cleared, it cannot be recaptured in the auto number field. Any other suggestions?