Password on a check box

[Ted D.]

Is there a way to password protect a check box ? The box
would not let you check it until the password has been
entered. also is there a way to hide data after it has
been entered?
Thanks
Ted D.

 

[Rick B]

There is no way to password protect a field. If the users can get to the
table, they can change it. You could build a password on a form. Just put
some code behind the checkbox that runs when the user tries to change it.
This should only be done if you are releasing the file in mde or have some
security in place so the user can't simply view the code.

To hide data? I'm guessing you want to enter something and have it masked
(like when you enter a password)? Or do you want a user to fill in a field
and then have that field become invisable after the user exits the field?

For the former, use an input mask of PASSWORD
For the latter, apply code to the afterupdate of the field that says
something like...
Me.SomeFieldName.Visible = False

Rick B



Is there a way to password protect a check box ? The box
would not let you check it until the password has been
entered. also is there a way to hide data after it has
been entered?
Thanks
Ted D.