Help me block out the first 5-digits of the SSN

[lebelerc]

I hope someone can help me. I have a report that prints out with the customers social security number on it. I need to change it so that only the last four digits of the SSN show, so it would like something like this XXX-XX-1234. I still want it to keep the full SSN in my Table though so we can search for the customers info with the SSN.

Is there a way that I can change it on the report only and not mess up any other forms that I have it on? Any help would be awesome!

 

[RV]

Base your report on a query.
In the query, use the Right function to extract the last four digits.
Concatenate with the number of X's you require:

'XX-XXXX-' & Right(SSN,4)

Could be you'll have to replace the comma by a semi colon.

RV

 

[ansentry]

In your report put an unbound text Box and put this as the control source.

=Right([txtSSN],4)

(Assuming that txtSSN is the name of your control)

 

[lebelerc]

That worked RV. Thanks so much for your help.

 

[ansentry]

Sorry I made a mistake, it should read:

="XXX-XX-"&Right([txtSSN],4)