How do I hide and protect a part of a form in access 2000

Z

Zeon

I want to hide a part of a form so some users can not see or access it,
however other users will be able to access the form if they enter a password,
how do I do this?
 
G

George

Dear firend,

Do you need to enter a password to open a form?

George

Ο χÏήστης "Zeon" έγγÏαψε:
 
K

Klatuu

You can really only hide a section of a form, Header, Detail, or Footer.
What you can do, if you need only a portion of a section visible, is to
create a Rectangle control. Set these properties:
Special effects = Flat
back color that is the same as the back color of the form's section it is in
Back Stype = Normal
Border Style = Transparent
Visible = True

When the form opens, you will not see any controls that are behind it;
however, when you tab to a control that is behind it, the control will show
up. What you will need to do is set the Enabled property to the controls you
want to hide to False. Then when a user enters a password to access the
controls behind the rectangle, you will need to enable the controls it hides.
 
Top