Kristen,
You need to modify the SS field's format in the TABLE to include the dashes.
Once the table is saved, the dashes will automatically "ripple" through
to all forms and reports.
Jim Meagher
> -----Original Message-----
> From: PCSOFT - Personal Computer software discussion list
> [mailto:[log in to unmask]]On Behalf Of Kristen K Smith
> Sent: Friday, October 13, 2000 9:48 AM
> To: [log in to unmask]
> 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?
>
> Thanks in advance for your help.
>
> Kristen Smith
> MIS Department
> The Haworth Press
> [log in to unmask]
>
> 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
>
> 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
>
PCSOFT maintains many useful files for download
visit our download web page at:
http://nospin.com/pc/files.html
|