Only show Last Four numbers of SSN

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

franklinbukoski - 19 Nov 2005 15:30 GMT

I have a form that shows SSN, but I want to limit what the cell shows to just
the last four. Any ideas?

Reply to this Message

Duane Hookom - 19 Nov 2005 15:52 GMT

Maybe:
=Right([SSN Field Name],4)

Make sure the name of the text box is not the same as a name in your
report's record source.

Signature

Duane Hookom
MS Access MVP
--

>I have a form that shows SSN, but I want to limit what the cell shows to
>just
> the last four. Any ideas?

Reply to this Message

Ofer - 19 Nov 2005 15:57 GMT

To get the last four digits use the right function
Right(FieldName,4)

he fisrt four digits
Left(fieldName,4)

Signature

Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck

> I have a form that shows SSN, but I want to limit what the cell shows to just
> the last four. Any ideas?

Reply to this Message

franklinbukoski - 19 Nov 2005 16:10 GMT

Duane/Ofer: Just like Excel! It didn't even occur to me, thank you!!!

> To get the last four digits use the right function
> Right(FieldName,4)
[quoted text clipped - 4 lines]
> > I have a form that shows SSN, but I want to limit what the cell shows to just
> > the last four. Any ideas?

Reply to this Message