Announcement

Collapse
No announcement yet.

Does Grid Mask Really Work?

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

  • Does Grid Mask Really Work?

    I'm trying to format a phone number 1234567890 as stored in the database to 123-456-7890. I entered XXX-XXX-XXXX in the Grid Mask field as specified in the documentation but it doesn't work. It displays as 1234567890. Am I misunderstanding what grid mask is or is there another way to format it so it displays on the PDF report correctly?

  • #2
    RESOLVED - it appears that the Grid Mask field does not format a return value from the grid lookup. Had to manually code a table lookup in the onRecord event and then set the field to the result set value. This properly formatted the phone number.

    Comment

    Working...
    X