Hi all!
How do I create an edit pattern for a United States telephone number in Base? How does the field need to be defined for this to work correctly? Text? Decimal? Number? Something else?
I want it to display in the entry form, queries and reports as 999-999-9999 with the dashes/separators. The data in the table can be in 9999999999 format (without the dashes/separators.)
Thanks in advance!