HOW DO I FORMAT A FIELD ON A FORM FOR A SOCIAL SECURITY FIELD TO: ###-##-####

Hey Becky,

Your solution may be a little different than mine, but I ended up using the formula below. I will be instructing the users of my app to exclude the hyphens from the social security numbers.

If(Length([SS#]) = 9,

var text SSN = ToText([SS#]);
var text filler = "###-##-#";

List ("", $filler, Right($SSN,3)),

"Not Formatted")

I'm not sure what your question is.

If you are trying to take a text field and  format it with hyphens then formula text field would be

var text PartOne = Left([SSN],3);
var text PartTwo = Mid([SSN,4,2);
var text PartThree = Right([SSN],4);

IF(Length([SSN]=9,
List("-", $PartOne, $PartTwo, $PartThree))


If he field was numeric then let me know and it would be slightly different formula

Still missing the close paren behind Length, Mark

var text PartOne = Left([SSN],3);
var text PartTwo = Mid([SSN,4,2);
var text PartThree = Right([SSN],4);

IF(Length([SSN])=9,
List("-", $PartOne, $PartTwo, $PartThree))