How can I show only the last 4 digits of SSN ?

G

Guest

I would like to show the last 4 digits, but I do not want the cell to show
the complete SSN. Any "simple ideas"?
 
D

Dirk Goldgar

imc626 said:
I would like to show the last 4 digits, but I do not want the cell to
show the complete SSN. Any "simple ideas"?
Click to expand...

A controlsource of

=Right([SSN], 4)

maybe? Or

="***-**-" + Right([SSN], 4)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate Text field and date field 4
Update/Append Queries 3
Passing value to a bound control 5
Show last four digits of SS# 3
Subform linked to master by SSN 3
linking fields which may be incomplete 2
How to pull records from multiple tables 4
How to display last for digits of SSN? 4

Top