Ron

I've written a reply to such as this before but can't find it. Essentially I wouldn't impose pnone no formatting at all. For instance in the UK most phone nos are of the form:

01999 999999, but they used to be 0999 9999. The big cities such as Liverpool have the form:

0191-999 9999, ({city}-{local exchange} {private no}), but they used to be 091-999 9999

The extra 1 came in with the proliferation in mobile (cell) phone nos.
London is a particularly complex case. As the capital its numbers used to be like:

01-999-9999, then it had to be split into inner and outer London, i.e

0171-999 9999 and 0181-999 9999, but these have now become something like:
020-7999 9999 and 020-8999 9999 (note now 4 digits in the local exchange)

and then there are the "letter" nos (like in the old days), such as 099 DOG WALK, so I wouldn't even format as numeric.

Could your formatting cope with all these different, and changing formats, and allow for the future?

Terry


>Can I please get some input on pros and cons of formating a phone number data field on a form. Save the entire entry in the data table "(555)555-5555", or just the numbers 5555555555 and add separators when populating the control. What about international notation 555.555.5555.
>
>TIA