Access - Dash mark won't print on labels

[Theresa]

In Access, I'm creating labels, and some of my numbers have dash marks in
them, ie. soc. security numbers.
The dash marks will not print.

 

[KARL DEWEY]

If it is SSN or phone number the dash may not be stored and therefore will
not print unless you format it in the report with dashes.

 

[Arvin Meyer [MVP]]

In a query:

Expr1: Left([SSN],3) & "-" & Mid([SSN],4,2) & "-" & Right([SSN],4)

in a form or report text box:

= Left([SSN],3) & "-" & Mid([SSN],4,2) & "-" & Right([SSN],4)

Where SSN is the name of your Social Security field.

Now, let me get on your case about storing personal information not required
by law. Unless this is a payroll program, you do not need to do it.