I am creating a CRM database in Base. I used the wizard to initially set this up. I successfully modified the Zip Code field to take either 5 or 9 digits and format them as “00000-0000”. But I cannot seem to do the same for the Phone Number. I attempted to format as “000-000-0000” and it just displays weird behavior. First it would change every phone number to a large negative number (the same number for every phone number). So I went in and formatted it to be identical to the Zip Code field, all except for the actual number formatting. Now the phone numbers just disappear. I enter the correct phone number, save, close, and when I re-open it, the phone number is gone.
Changes that I made to the Phone Number field: changed the field from txt to fmt; changed the formatting in the property control. Changed the minimum value to 000-000-0000 and the maximum to 999-999-9999 (although this is not how the ZipCode field is formatted, I do not know how to get the equivalent), removed the default value.
Despite removing the default value, it still defaults as 000-000-0000.
I have already read this post but I don’t understand the difference between that, and what is clearly working for the ZipCode field, so I don’t know if that is the option that I need, or why… or why/how they are different.