Formating SSN that start with zero

[zenman]

I am using a calculation with a field mask to display a SSN properly formatted. I have found that SSN begining with zero do not format properly and a number is added in (ex.012346789 displays as 123-46-6789) What am I doing wrong here?

SSN field is formated as text

SSN Mask field is formated as a Calculation with calculation result being text (this is the only way I didn't get some funky formula while tabbing through the record), and the calculation is.

Left(Abs(SSN), 3) & "-" & Middle(Abs(SSN), 4, 2) & "-" & Right(Abs(SSN), 4)

Thanks in advance!!

[BobWeaver]

I'm not sure why you used the abs() function, but I suggest making a text field version of the SSN with leading zeroes added like this:

cTextSSN = Right("000000000" & Substitute(NumToText(SSN),"-",""), 9)

Then your formatted SSN will be:

Left(cTextSSN, 3) & "-" & Middle(cTextSSN, 4, 2) & "-" & Right(cTextSSN, 4)