Partially mask a text box 1

[mjake13]

I have a text box on a report that contains a social security number. I want to only display the last four digits and have the remainder show as some type of symbol. I can't get the formatting to work right. Any suggestions?

 

[dhookom]

Set the control source to something like:
="XXX-XX-" & Right([SSN],4)
Make sure the name of the control is not the name of a field.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mjake13]

Thanks Duane.

Modified it just a bit to suit, but it worked perfectly.

=IIf(IsNull([SSN]),"","XXX-XX-" & Right([SSN],4))