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
Tagged with: access data • computer geek • data base • job
Filed under: Computer Data Security
Like this post? Subscribe to my RSS feed and get loads more!
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.
Isn’t that illegal ? .. To answer you .. yes you can do it if you know how. Good Luck ! :)
string