Prevent field access by password

[Paulo Ferreira]

Hello,

Can someone tell me how to prevent access to a field on a form, by password.
Thanks,

Paulo Ferreira

 

[Arvin Meyer]

Hello,

Can someone tell me how to prevent access to a field on a form, by

password.

You can't mask the password with this, but it does work (and fast too)

Private Sub txtWhatever_Enter()
If InputBox("Enter your password") <> "Scooby Doo" Then
DoCmd.Quit
End If
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Paulo Ferreira]

It's working.
Thanks

Paulo Ferreira

password.

You can't mask the password with this, but it does work (and fast too)

Private Sub txtWhatever_Enter()
If InputBox("Enter your password") <> "Scooby Doo" Then
DoCmd.Quit
End If
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access