x out the first part of a ssn on report 1

[MICKI0220]

How would I mask out the first part of someone's social security on a report so that it shows something like this.....xxx-xx-6065

Thanks for your help

Micki

 

[dhookom]

Simply set the control source to

="xxx-xx-" & Right(ssn,4)

Make sure the name of the control is not the name of a field.

Duane
Hook'D on Access
MS Access MVP

 

[MICKI0220]

Thanks it worked great.