AnsweredAssumed Answered

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

Question asked by EmmettOliver on Jul 5, 2011
Latest reply on Jul 5, 2011 by 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

Outcomes