Masking SSNs with ***-**-xxxx

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to find a way to display the SSN's in a report, query etc with
the last 4 only.
Thank you
 
I am trying to find a way to display the SSN's in a report, query etc with
the last 4 only.
Thank you

Use an unbound control in the report.
Set it's control source to:

="***-**-" & Right([SSN],4)
 
Back
Top