I can help with this.  Is the Social Security Number stored in the
database formatted with the dashes or is it stored only as the digits?
I'm assuming that you have them enter a SSN with the dashes and use it
as a criteria in the query?  This would imply that the SSN is stored in
the database with the dashes so maybe I've answered my own question.
You should be able to accept their input into a parameter without dashes
and compare it against a copy of the SSN where you have removed the
dashes from the database copy.  I don't have Access installed at home so
I cannot try this and show the query but I can do it at work on Monday
after you've answered the questions above.

----- Original Message -----
From: Kristen K Smith <[log in to unmask]>
To: <[log in to unmask]>
Sent: Friday, October 13, 2000 9:48 AM
Subject: [PCSOFT] Parameter queries in Access


> I have a question for those of you who are experienced with Microsoft
> Access 97 &/or 2000.
>
> I am creating a report based on a parameter query.
> The query prompts the user for social security number and date.
> The user for whom I am modifying this database often mistypes the '-'
> character
> in the social security number, and would prefer not to have to enter
it at
> all.
> Does anyone know a way to apply an input mask on the prompt which asks
for
> this information?

               The NOSPIN Group Promotions is now offering
      special "Free-After-Rebate" Software specials in conjunction
          with Beyond.com.   We have new offers all the time!!!
                      http://nospin.com/promotions