Microsoft Access - Database form - Asked By aashni malde on 12-Jun-12 09:24 AM

how do you password protect a field such as a tick box to being password protected?
when you want to tick the check box a password is required.

You can just use the click event:

Private Sub Check0_BeforeUpdate(Cancel As Integer)

    varReply = InputBox("Requires password to continue", "Enter Password")
    If varReply <> "password" Then
      Cancel = True
    End If

End Sub

Not the most secure.  If you want to get fancier you can create a userform with a masked password, and there are routines to hash the password so you don't have it stored in code.