How to display last for digits of SSN?

[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.

 

[fredg]

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.

 

[Jerry Whittle]

In a query:

Last4: Right([SSAN_Field],4)

 

[De Jager]

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.

 

[Armen Stein]

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