Prevent field access by password

  • Thread starter Thread starter Paulo Ferreira
  • Start date Start date
P

Paulo Ferreira

Hello,

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

Paulo Ferreira
 
Paulo Ferreira said:
Hello,

Can someone tell me how to prevent access to a field on a form, by
Click to expand...
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
 
Back
Top