Mask Format for SSN

M

Me Not You

I'm trying to figure out how to mask the SSN so it will only show the last 4
digits. I'm trying to do this in a report but nothing I have tried works.
 
C

Cheryl Fischer

=Right([MySSNField], 4) in the ControlSource property of a text box
should do it for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting a Combo box 12
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Show Button 5
Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
Hide allbut last four characters of a social security number 1
Combo Box With SSN Input Mask 0
Format of SSN Field on Form 2
Input Mask 0

Top