Format a social security in an Access report

L

lschuh

I do not know the syntax to get a field to print out in the correct format.
I have a social security number that is being entered into a table using the
input mask. It is printing out without the dashes. EG (123446123). I can't
remember the correct syntax to use. Thanks
 
J

John Spencer

Format([SSN],"@@@ @@ @@@@")

Or

Format([SSN],"@@@-@@-@@@@")

If you are using the format property of the control then use the following
in the property
@@@ @@ @@@@
or
@@@-@@-@@@@

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
L

lschuh

Thank you so much, it works great.

John Spencer said:
Format([SSN],"@@@ @@ @@@@")

Or

Format([SSN],"@@@-@@-@@@@")

If you are using the format property of the control then use the following
in the property
@@@ @@ @@@@
or
@@@-@@-@@@@

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

lschuh said:
I do not know the syntax to get a field to print out in the correct format.
I have a social security number that is being entered into a table using
the
input mask. It is printing out without the dashes. EG (123446123). I
can't
remember the correct syntax to use. Thanks
Click to expand...
Click to expand...
 

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

Masking a field in Report only 2
How to remove dashes in Social Security number 15
How do I do display xxx-xx-1234 in an access report 10
Dashes in Social Security Number 4
Unformating social security numbers 4
Social Security Number format 1
Format Cells - Custom 1
Print Social Security as formatted. 3

Top