If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Show Button
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. |
#2
|
|||
|
|||
Show Button
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 |
#3
|
|||
|
|||
Show Button
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 . |
#4
|
|||
|
|||
Show Button
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 |
#6
|
|||
|
|||
Show Button
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 "Tammy S." wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|