how do I show part of a field on a report in access?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Randy - 07 Dec 2005 23:38 GMT

I use social security numbers in my database. I want to show only the last 4
digits of the number on my reports for security reasons. How do I?

Reply to this Message

Duane Hookom - 08 Dec 2005 02:25 GMT

Right([ssn],4)

Signature

Duane Hookom
MS Access MVP
--

>I use social security numbers in my database. I want to show only the last
>4
> digits of the number on my reports for security reasons. How do I?

Reply to this Message

Randy - 08 Dec 2005 14:54 GMT

Thanks. Where should I place this, in the report or query or what? I have
tried several locations and it isn't working.

> Right([ssn],4)
>
> >I use social security numbers in my database. I want to show only the last
> >4
> > digits of the number on my reports for security reasons. How do I?

Reply to this Message

Duane Hookom - 08 Dec 2005 18:12 GMT

"it isn't working" does not tell us much.
You can set the control source of a text box to:
=Right([Your ssn field name],4)
Make sure the name of the control is not the name of a field.

Signature

Duane Hookom
MS Access MVP
--

> Thanks. Where should I place this, in the report or query or what? I
> have
[quoted text clipped - 6 lines]
>> >4
>> > digits of the number on my reports for security reasons. How do I?

Reply to this Message

Randy - 08 Dec 2005 18:27 GMT

Thanks for the help. I figured out where to put the info.

> "it isn't working" does not tell us much.
> You can set the control source of a text box to:
[quoted text clipped - 11 lines]
> >> >4
> >> > digits of the number on my reports for security reasons. How do I?

Reply to this Message