Mask for SSN field

[5835]

in my database, i have a field SSN. the problem is every time i enter data, i have to put in the hyphens. is there a way i can make the hyphens automatically show up: 123-45-6789. i would also like on for date: MM/DD/YYYY. i know this is a piece of cake for you guys but please help me out. it will save me hours.

thanks

 

[phaeberle]

This can only be done through a calculation field.
If you have SSfield (where the users are going to enter the SS)
You have to create a calculated field cSSfield that contains the following formula:

Left(SSfield, 3) & "-" & Middle(SSfield, 4,2) & "-" & Right(SSfield,4)

In the data entry form, you have to do the following:

place the calculation field on top of SSfield.
Make sure that only SSfield can be edited.
Make sure not use transparent fields.

hope it helps