Access - Dash mark won't print on labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and Replace 3
zip coe 1
Dashes in Social Security Number 4
Using the dash "-" in an index 7
Form Question?: Field and Label seem to be linked in design view 2
Removing Dashes in Excel 4
FIND ALL 1
How to remove dashes in Social Security number 15

Back
Top