Show Button

T

Tammy S.

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

Clifford Bass via AccessMonster.com

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
 
T

Tammy S.

It worked beautifully. Thank you.

Clifford Bass via AccessMonster.com said:
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
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.
 
S

sebastien

Tammy S. said:
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.
 
L

Larry Linson

Depending on the circumstances and situation under which the Show button can
be used, you may be in violation of privacy legislation. I strongly doubt
that just including an admonition "Do Not Disclose" is, in itself,
sufficient. We aren't attorneys here, and can't give legal advice, but I'd
suggest you obtain reliable legal advice regarding your approach.

Larry Linson
Microsoft Office Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste options button disappears 0
Not current record 0
Matching record 0
Saving data 1
Setting up a form 7
Dynamic Naming of Form Button 3
FileSearch Help 2
how do I alert user (ASAP) if record already exists? 2

Top