password protecting

[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

 

[Art]

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

 

[TC]

What do you mean by "admin"?

TC

 

[German Saer]

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!

 

[TC]

*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