I have a form (created in MSAcc97) that allows users to enter in numerous fields. Some of these fields are date fields with an input mask of ??/??/??. For example, if I should enter 01302 it would return 01/03/02.

I have validation set on these fields on the validation rule in the properties dialog box. If the user enters an incorrect date a warning box appears informing them of the validation rule (OK). But in order to re-enter the correct value the user then has to pres ESC to undo the incorrect value first.

I am almost ready to distribute this application on the network and I just know that someone will press this ESC key twice in error.

If the user presses the ESC key twice it makes the record disappear. Upon investigation the record does not appear to have saved either.

Any suggestions.

Thanks

Esc-Esc sends Me.Undo in Access, so it is working "as designed". However, to change it, try this topic: http://www.access-programmers.co.uk/ubb/Forum7/HTML/002417.html

Keep in mind that you will not be able to use this to backout of badly validating code loops, so you should add a physical 'Undo' button or something similar.

HTH,
David R