How do i make a SSN "Social Security Number" data type in MS access?

I want to set up a field in an Access data base with a SSN style auto format Example, when i input 123456789, id like it to format to 123-45-6789 ... I got appointed this job being the "Computer geek" of the office but i have little to no experience with Access... thanks

How do i make a SSN "Social Security Number" data type in MS access?viruses

1)in the field of SSN in your table chose the datatype number or if it contains text then choose text.

2)change the format to your SSN format, you can even create your new one.

How do i make a SSN "Social Security Number" data type in MS access?antispam

Isn't that illegal ? .. To answer you .. yes you can do it if you know how. Good Luck ! :)
string