Hide first part of someones SSN

[waysofolde]

I am working with an access database and in the table, under the design view I have a field where I am inputting an ssn.

Is there a way that, when I create a report, I can have access hide the first part of the persons ssn and only show the last 4?

Thanks for all your help

[orange]

I am working with an access database and in the table, under the design view I have a field where I am inputting an ssn.

Is there a way that, when I create a report, I can have access hide the first part of the persons ssn and only show the last 4?

Thanks for all your help


You might be able to just use Left(ssn,4) to get the last 4 positions. But should you be exposing anything of the SSN?

Just a questiion.

[CreganTur]

You'd actually need to use Right(ssn,4) to get the last 4 digits of the SSN.

Also, if you use:
Dim SecureSSN As String

SecureSSN = "XXX-XX-" & Right(ssn,4)

Would show 123-45-6789 as XXX-XX-6789

[orange]

You'd actually need to use Right(ssn,4) to get the last 4 digits of the SSN.

Also, if you use:
Dim SecureSSN As String

SecureSSN = "XXX-XX-" & Right(ssn,4)
Would show 123-45-6789 as XXX-XX-6789

Yes, Right(ssn,4). Must have been late when I answered?

What about use of ssn and making any of it public?
Is this for some internal use? Just asking since normally we don't use SIN (Social Insurance Number) in Canada - somewhat equivalent to ssn . It's a privacy thing.

[waysofolde]

Thank you for your help, it's worked perfectly.

Yes, this is for something internal, and we use the last 4 for tracking purposes, don't want the whole ssn out there for the world to see.