Mask SSN (show all numbers but last) on report

[floyd33 via AccessMonster.com]

I know this is not advisable since you are not really hiding the stored data,
but is there a way to show the social as "012-22-234*"?

I've tried this "=Left([SSTaxID],10)" but I don't know how to get that * on
the end. I've added &"*"& at the end, but it doesn't work. Any help is
greatly appreciated.

 

[John Spencer]

This should work if SSTaxID is stored as nnn-nn-nnnn
LEFT([SSTaxID],10) & "*"

I must say that in most cases the practice is to show only the last 4. Which
would be
"***-**-" & Right([SStaxID],4)

This does not hide the data in the table, but it does on a printed report.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[floyd33 via AccessMonster.com]

Perfect, thanks. I am aware of the best practice, but this was a special
request from the user. I realize there is absolutely no security behind it.

This should work if SSTaxID is stored as nnn-nn-nnnn
LEFT([SSTaxID],10) & "*"

I must say that in most cases the practice is to show only the last 4. Which
would be
"***-**-" & Right([SStaxID],4)

This does not hide the data in the table, but it does on a printed report.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

I know this is not advisable since you are not really hiding the stored data,
but is there a way to show the social as "012-22-234*"?

I've tried this "=Left([SSTaxID],10)" but I don't know how to get that * on
the end. I've added &"*"& at the end, but it doesn't work. Any help is
greatly appreciated.