January 10, 200521 yr 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?
January 10, 200521 yr 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.
Create an account or sign in to comment