M Me Not You Apr 27, 2004 #1 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.
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 Apr 27, 2004 #2 =Right([MySSNField], 4) in the ControlSource property of a text box should do it for you.