I have a varchar field and I want to have the user enter 123-123-1234 for the phone number. I would prefer them not to have to enter the dashes for the phone number.
I put a grid mask on the form of 999-999-9999 and that seems to work fine, except when I do the same on my grid it looks this this
123-123-1234999-999-9999
which of course is not correct.
If I leave the Grid Mask blank I get
1231231234
which is not what I want.
Using most current version of SC.
Can someone tell me what I’m doing wrong??
I would actually prefer the actual field saved in the database to be in the format 123-123-1234 so that anytime I display it, I wouldn’t have to worry, but was not sure how to do that.
Alan