Social Security Number

[Dnewc1965]

Is there a way to format a number field as a ss# without typing in the dashes

[DykstrL]

You can do it with a calculation field:

Middle(NumToText(Abs(TextToNum(SSNEnter)*10000000)), 1, 3) & "-" & Middle(NumToText(Abs(TextToNum(SSNEnter)*10000000)), 4, 2) & "-" & Middle(NumToText(Abs(TextToNum(SSNEnter)*10000000)), 6, 4)

The result should be text

[BobWeaver]

Also, you can locate the calculated field directly in front of the field in which you enter the data, and set the format to not allow entry to the field. Then they will appear to be a single field with only the formatted number displaying after you exit the field.