Format a social security in an Access report

[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

 

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

 

[lschuh]

Thank you so much, it works great.

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

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