2 Replies Latest reply on Jul 5, 2011 11:59 AM by EmmettOliver

    SSN formatting not displaying except in browse mode with the cursor in the field

    EmmettOliver

      Title

      SSN formatting not displaying except in browse mode with the cursor in the field

      Post

      Hello,

      I am using the

      let ( ssn = Filter(Self; "0123456789"); if (length( ssn ) = 9 ; left(ssn ; 3 ) & "-" & Middle(ssn; 4; 2 ) & "-" & right(ssn; 4) ; ssn ) )

      auto-entered calculation for SSN fields.  the do not replace existing value check box is clear.  it seemed to work for the first field i created and tested, but when added to other fields, the number appears unformatted except in browse mode with the cursor inside the SSN field.  Should it be formatted as a script on object exit?

      Thanks,

      Emmett