Tel mask

[John]

Hi

What mask will turn a tel number into format 999<space>9999<space>9999?

Many Thanks

Regards

 

[ghetto_banjo]

Create a new input mask (you click on Edit List) and make it:
### ### ####

 

[Tony Toews [MVP]]

What mask will turn a tel number into format 999<space>9999<space>9999?

You're in the UK but you're asking about North American phone number
format?

I just give my users a text field and tell them to enter the phone
number how they want.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[John]

clients want it that way...and they are the boss