Input Mask - International Phone numbers

N

nrodADAA

Is there an input mask for numbers that have an international code? I have a
number listed as 011496221-172229. I would like it to read in the format
+44-(0)1224-XXXX-XXXX or is there a more proper format?

I am using Access 2007, Windows XP.
 
J

Jerry Whittle

International phone number, and to similar extent, postal codes vary so much
between countries that I recommend not even trying to use an input mask.
 
P

Paul Shapiro

While some countries, like USA and Canada, have very consistent phone number
formats, other countries have significant variation even within the same
country. You can find websites listing the various country numbering plans.
The best you could do is create a table of countries and specify an input
mask for each country, or at least those countries that are amenable to an
input mask. I think input masks are more harm than help unless they can be
perfect, so I would usually not use one for international phone numbers.
 

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

Top