Can you bypass an "Input Mask"

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
 
D

Dan Artuso

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Phone # input mask 4
Input mask & Format question 2
input internat'l phone #s where input mask set for US #s 1
Syntax error on an input mask that was created by the wizard 2
Word Create a Phone Book using MailMerge in word 2007 0
Autoexpand on a phone input mask 2
Input Mask For Phone Number 4
Print concatenated formatted text in report 2

Top