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

  • Thread starter Thread starter Guest
  • Start date Start date
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"?
 
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)
 
You must log in or register to reply here.

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

Passing value to a bound control 5
Update/Append Queries 3
Concatenate Text field and date field 4
filter query 1
Subform linked to master by SSN 3
joining on mis-matched data type 5
How to pull records from multiple tables 4
Trim all but the last four digits off a list of SSN's. 2

Back
Top