We are trying to implement a Clear button on a form, a button that would erase all entries during a record add and undo changes when the user is editing a record. The way we are current trying to do this is simply with the code:
This does what we want except for when the user has entered something in the text box with a mask but hasn't completed the entry when adding a record. In this case the user gets a mask violation error. It's pretty stupid to require the user to enter valid data before they can clear it.Code:Me.Dirty Then Me.Undo
We need the mask. So the question is how can we implement a Clear button and still have a mask, but not the bogus error message.
Well actually we could get rid of the mask by separating the SOP number, the text box with the mask, into separate fields in the table, but at this point that would be a lot of work.
The attached database, a single form and table from a training requirements database, demonstrates this problem.
I posted this at http://www.access-programmers.co.uk/...d.php?t=284535 but didn't get any replies