Search results

In a form, I have a combo box from which the user can select either Phone or Email. I also have an Email text box on the form. How can I make the Email text box field required only when Email is selected in the combo box? Thanks for the help.

Finally had time to get it to work! Thank you very much, ajetrumpet!

The phone number is all one field with the aforementioned mask applied. I set a validation rule for the first 3 characters in the field so that it only accepts number combinations that are valid area codes for my location. I would like to use the code suggested, so what do I need to change to...

Thanks for the quick response. The area codes I have handled--it's the remaining 7 digits that have me stumped. And yes, the data is being entered in a form. I need to verify that neither the 3-digit prefix nor the last 4 digits are all zeros. In other words, something like (303) 000-1234...

I have a field with the US phone number mask applied. I can validate the first 3 digits of the field to require a valid area code, but how can I validate the remaining 7 digits to prevent users from doing an end run around the required field by entering all zeros instead of a vaild phone number?