There are sophisicated ways of doing this. I am not sophisticated. I try to code for worst situation.
PhoneArea (field options - verified numbers only)
PhoneFull - calculation field IF PhoneExtension IsEmply etc "(_ " & PhoneArea & "_" & PhoneNumber & "_x" & PhoneExtension
How do I create a data input mask for formatting telephone numbers?
Answer ID: 5839Last Updated: Oct 04, 2011
How do I format a Telephone Number?
Answer ID: 5247Last Updated: Oct 02, 2009