Report to only show last 4 digits of social security number

[velcrowe]

I have a report to print that only shows the last 4 digits of the Social Security field. How can I do so for the entire list of social security #'s.

Thanks in advance.

 

[boblarson]

Set the recordsource of the text box that displays the records to be:

=Right([YourFieldNameHere],4)

or use the same thing in the underlying query (probably even better)

NewSSNField:Right([YourFieldNameHere],4)

 

[velcrowe]

Report to Show last 4 digits of social

Thank you it worked great.

 

[Clownfish1980m]

Thank you so much. I have been trying to do the same thing through VBA programing. I didn't realize it was easier to do it this way. Thanks again.

 

[boblarson]

Thank you so much. I have been trying to do the same thing through VBA programing. I didn't realize it was easier to do it this way. Thanks again.

Glad the site could help you out.