password protecting

  • Thread starter Thread starter Cameron
  • Start date Start date
C

Cameron

I was wondering can you password protect certain text
boxes on a form so that only admin can change whats
diplayed in that text box? I dont want the whole form
password protect as there some things i need to allow
changes be done by anyone.

TIA
 
Hi Cameron
Set the Locked Property of those text boxes to
YES. Only you should be able to go into design view and
change them.

Hope This Helps
 
Yes, you can.

OnCurrent Method of the form:

If CurrentUser = "Admin" Then
MyTextBox.Visible= False
Else
MyTextBox.Visible= True
End if

and that's it!
 
*If* he has implemented user level security. But there's no evidence that he
has actually done so. In that case, CurrentUser() is no help to him. That's
why I asked him what he meant by "admin" :-)

TC
 
Back
Top