password protect a textbox?

  • Thread starter Thread starter David
  • Start date Start date
D

David

Is it possible to password protect a textbox.
What I am thinking (and it may be wrong), is that when someone really wants
to change a previous record(which would create a few problems) how would you
go about this. Would you protect a textbox on a form or would you protect
the form. If so how would you go about this?, or is there a good link that
you could refer me to
Thanks
David
 
I would lock the textbox and set the keydown event to
either pop a msgbox asking if the user really intends the
change, or an inputbox requiring a password. If they
respond "no" or don't know the password, docmd.cancelevent.

Hope this help!
 
Back
Top