How to display last for digits of SSN?

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

I need to display on a form the last for digits of a social security number.
How do I limit the display? in query? form field properties? what is the
criteria?
Thanks.
 
I need to display on a form the last for digits of a social security number.
How do I limit the display? in query? form field properties? what is the
criteria?
Thanks.

Add an unbound control to the form.
Set it's Control Source to:
=Right([SSN],4)

Change SSN to whatever the actual social security field name is.
Make sure the name of this control is not the same as the name of the
social security field.
 
Denise said:
I need to display on a form the last for digits of a social security
number.
How do I limit the display? in query? form field properties? what is the
criteria?
Thanks.
 
Set it's Control Source to:
=Right([SSN],4)

Or you can format it in a way that is often used to show obscured
SSNs:

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

This will show it in format ***-**-1234 if there is a value there. By
using the + for concatenation, it will show nothing if the SSN is
null.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Back
Top