Last 4 Digits of SSN

[mommom]

I have a database that they need to have the entire SSN listed. However, when a report is printed out they only want the last (4) digits showing. How can I make that happen?

 

[snyperx3]

Have two textboxes on the report. One will have the control source set to the SSN field, but it will have the value Visible set to False. The other will have a control source of
=Right(SSN,4)

*assuming the name of the ssn field is SSN

-Pete

 

[mommom]

Thank you Snyperx3. Worked great!