Validation rule - How to handle violation?

[Guest]

I have a validation rule set up in a text input box. When the rule is broke,
I have a message display that the rule has been broke and what the user
should enter to satisfy the rule. Is there any way I can set up a simple
command button to let the user cancel the event and start over. For some
users it may seem less confusing if there is a cancel button.

 

[Allen Browne]

No. You cannot put a command button on the form to handle this situation,
because any attempt to click the command button will trigger the text box's
validation *first*, and so the button's click event will never be triggered
if the data is bad.

Of course, the user could click the Undo button on the Toolbar (or press
Esc.)