Using a command button to clear all fields in a form after data validation error has been generated

[TrainingExcellence]

I have a form containing multiple required textboxes with data validation. I have created custom validation messages. Currently, if a user enters an invalid value, the message will appear, telling them to enter an acceptable value. The user cannot navigate elsewhere until they enter a valid value.

Also on the form, I have a button that clears the current record. I would like the form to work in such a way that if a data validation error is generated, the user has the option of clicking the clear button to clear all fields in the record. Currently, if a validation error is generated and the user attempts to click the clear button, the validation error will appear, forcing the user to enter a value. The user could hit the ESC key to clear the textbox, but I'm building this form for people who wouldn't know about the ESC key, and I would prefer to not have to educate them.

Any suggestions for how to set this up?

Thanks!

[GinaWhipp]

Hmm, perhaps coding your Clear buttons to...

If Me.YourControl <> "" Then
     Me.YourControl .Undo
     Cancel = True
End If

...will work.

[Micron]

Me.Undo will clear the whole form. I only read mention of one button, not many

clear button to clear all fields in the record.

but you can undo every control one by one as suggested if that's not the case.