Cancel button and input mask input

[mscertified]

I have a form with bound controls, some of which are phone nos with input
mask (000) 000-0000. The form has a CANCEL button. How can I code the Cancel
button to get past the situation where I have entered invalid data for the
mask. For instance, if the user enters just the area code and then hits
Cancel, I still get the Access message 'the data you entered is invalid for
the input mask'. I cannot exit from the screen until I have erased this data.

 

[Stockwell43]

,Hi,

I am sure there are other ways around it but, if all the information is not
inputted then you would either need to fill in the rest with 1's OR just
remove the input mask. I know this is not what you were probably looking for
but, I think if you use the input mask you almost have to have the field
completed.

 

[mscertified]

Thanks for the response.
Unfortunately, that does not work, before I can get control to do
*anything*, the Access message appears.

 

[Stockwell43]

Did you try to remove the Input Mask function all together? If need be,
delete the field and replace it with a new textbox. Are you able to have the
area code but the rest of the field all 1's? Sometimes the simplest things
are the most annoying aren't they.

 

[mscertified]

That is no good, I have to have the input mask to validate the input.

 

[Linq Adams via AccessMonster.com]

As someone once said here, "Input Masks are Evil!"

There are other ways to assure that your data is formatted correctly. What
kind of data is this?

 

[mscertified]

was stated in my first post. phone number in format (000) 000-0000