Announcement

Collapse
No announcement yet.

Grid Mask

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Grid Mask

    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

  • #2
    I ended up changing the 999-999-9999 to ###-###-#### and I think it's going to work better.

    Comment

    Working...
    X