Can you bypass an "Input Mask"

  • Thread starter Thread starter Steve P
  • Start date Start date
S

Steve P

Is there a way to bypass an input mask for a very small number of records
that do not conform. Namely a phone number. I have a database that has over
20,000 contacts and of those maybe 5 are from foreign countries with
international phone number formats. The rest are standard (999) 999-999
numbers. Any suggestions would be appreciated.

Thanks,
SteveP
 
Hi,
Sure, just put a comand button on your form with code like this
in the click event:
Me.txtMask.InputMask = ""

change txtMask to your text box's name
 
Back
Top