Prev: Form size properties seem to have no effect.
Next: CONTROL PROPERTIES VISIBLE = NO (HIDING CONTROLS)
From: Tammy S. on 8 Jan 2010 11:25
I have a show button I need to code so it will show social security number
with a disclaimer.

SSN is set as password so it shows only asteriks in the form. On clikding
the Show SSN button, I would like it to pop up a box with the disclaimer
"Privacy Act Data; Do Not Disclose." I need it to say "User's SSN is
(showing the SSN for that record)" with an OK button to click to close.

SSN field name is SSN (surprise)
ShowSSN button is btn_ShowSSN

Thank you.
From: Clifford Bass via AccessMonster.com on 8 Jan 2010 13:07
Hi Tammy,

I would think you could use a MsgBox to do that.

MsgBox "User's SSN is " & [SSN] & ".", _
vbOKOnly + vbInformation, _
"Privacy Act Data; Do Not Disclose."

Clifford Bass

Tammy S. wrote:
>I have a show button I need to code so it will show social security number
>with a disclaimer.
>
>SSN is set as password so it shows only asteriks in the form. On clikding
>the Show SSN button, I would like it to pop up a box with the disclaimer
>"Privacy Act Data; Do Not Disclose." I need it to say "User's SSN is
>(showing the SSN for that record)" with an OK button to click to close.
>
>SSN field name is SSN (surprise)
>ShowSSN button is btn_ShowSSN
>
>Thank you.

--
Message posted via http://www.accessmonster.com

From: Tammy S. on 8 Jan 2010 14:23
It worked beautifully. Thank you.

"Clifford Bass via AccessMonster.com" wrote:

> Hi Tammy,
>
> I would think you could use a MsgBox to do that.
>
> MsgBox "User's SSN is " & [SSN] & ".", _
> vbOKOnly + vbInformation, _
> "Privacy Act Data; Do Not Disclose."
>
> Clifford Bass
>
> Tammy S. wrote:
> >I have a show button I need to code so it will show social security number
> >with a disclaimer.
> >
> >SSN is set as password so it shows only asteriks in the form. On clikding
> >the Show SSN button, I would like it to pop up a box with the disclaimer
> >"Privacy Act Data; Do Not Disclose." I need it to say "User's SSN is
> >(showing the SSN for that record)" with an OK button to click to close.
> >
> >SSN field name is SSN (surprise)
> >ShowSSN button is btn_ShowSSN
> >
> >Thank you.
>
> --
> Message posted via http://www.accessmonster.com
>
> .
>
From: Clifford Bass via AccessMonster.com on 8 Jan 2010 14:48
Hi Tammy,

You are welcome!

Clifford Bass

Tammy S. wrote:
>It worked beautifully. Thank you.
>
>> Hi Tammy,
>>
>[quoted text clipped - 18 lines]
>> >
>> >Thank you.

--
Message posted via http://www.accessmonster.com

From: sebastien on 10 Jan 2010 08:59


"Tammy S." <TammyS(a)discussions.microsoft.com> a écrit dans le message de
groupe de discussion : C0DF2D59-CD27-4EF7-A91B-2E7C52232D44(a)microsoft.com...
> I have a show button I need to code so it will show social security number
> with a disclaimer.
>
> SSN is set as password so it shows only asteriks in the form. On clikding
> the Show SSN button, I would like it to pop up a box with the disclaimer
> "Privacy Act Data; Do Not Disclose." I need it to say "User's SSN is
> (showing the SSN for that record)" with an OK button to click to close.
>
> SSN field name is SSN (surprise)
> ShowSSN button is btn_ShowSSN
>
> Thank you.
>
 |  Next  |  Last
Pages: 1 2
Prev: Form size properties seem to have no effect.
Next: CONTROL PROPERTIES VISIBLE = NO (HIDING CONTROLS)