SSN printed with extra dashes 1 time

  • Thread starter Thread starter Anthony Fontana
  • Start date Start date
A

Anthony Fontana

I have a database storing soc sec numbers and names. The soc sec numbers are
entered on a form with a picture clause of 000\-00\-0000;0;_

I have a report (complicated format) that grabs information from the form
and prints out the Soc Sec Number. It has a picture clause of @@@-@@-@@@@

For one client and one client only, the SSN prints out 111-2-3--5555
All others print out 111-23-5555

Does anyone know why this happens. Win XP SP2 and Access 2003 system running

Thanks in advance
 
It is very probable that the SSN that has the problem already has the dashes
in it or is otherwise malformed.

Format("123-45-6789","@@@-@@-@@@@") will return 123--4-5-6789

Try searching the table for a record that does not match the pattern
"#########"

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
Thanks. I'll try that.


John Spencer said:
It is very probable that the SSN that has the problem already has the dashes
in it or is otherwise malformed.

Format("123-45-6789","@@@-@@-@@@@") will return 123--4-5-6789

Try searching the table for a record that does not match the pattern
"#########"

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County


.
Click to expand...
 
Back
Top