SSN printed with extra dashes 1 time

[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

 

[John Spencer]

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

 

[Anthony Fontana]

Thanks. I'll try that.

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


.