Validate Phone Number Format

[Papabjoe]

My phone number fields are set to format the data as ###-###-####. However, when my users do not enter the area code it appears as ###-###-#. Can anyone give me an example of a validation calculation that will result in a message to enter the entire number including the area code?

[andygaunt]

Well, you could look for the length of the field and then show a validation dialog if it only sees 7 characters.

You could also jsut ### out the area code if the length is only 7. Presuning you are filtering the number field to apply your own formatting.