Input Mask - International Phone numbers

  • Thread starter Thread starter nrodADAA
  • Start date Start date
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.
 
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.
 
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.
 
Back
Top