Hide data in a field

[Tammy S.]

I have a database that includes information protected by the Privacy Act. I
want to show the field, but with stars in place of the data and a button
allowing the data to be viewed with a breif statement indicating the data is
protected by the Privacy Act. I aslo need to enact security on this feature
so only specific users can access this data. Can anyone help me with this?
Thank you.

 

[Tom van Stiphout]

On Wed, 11 Nov 2009 09:31:05 -0800, Tammy S.

You're asking a very broad question so you can't expect a very
specific answer.
Stars: Sure: just set the InputMask to Password.
Specific Users: This all depends on how you determine which users have
access. In the Form_Open you could write:
if not IsSpecificUser() then Me.myTextbox.InputMask = "Password"

Then write a function IsSpecificUser where you decide who has access.
The implementation will depend on how you determine this: from the
Windows login, from Active Directory, from a custom Users table, from
workgroup security, etc....

-Tom.
Microsoft Access MVP