SSN formatting not displaying except in browse mode with the cursor in the field
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?