Mask A Field In A Form

Access 2000
Table tbl_TEMP
Table tbl_TESTS
Query qry_TESTS
Form frm_TESTS

There are 10 records in tbl_TEMP. Form frm_TESTS shows each record. My user makes changes to the record and clicks an “Accept” button, which excuses a VB script that appends data from tbl_TEMP into tbl_TESTS. That all works perfect.

There is a general text field in tbl_TEMP that will become a Social Security masked field once transferred to tbl_TESTS. Right now if someone attempts to accept the test and the [ssn] field is not truly in the proper mask of xxx-xx-xxxx then it will look as if it is appending the test, but it truly does not copy the record.

Can I add a warning somewhere that makes them change any text in that field to the proper mask?

So ex: if they see “123456” in the [ssn] field in the form they must change it to “123-45-6000” or any other system they choose to fill it in, but make it where they much change it before they can “Accept” the test?

Thanks.