Tricks for a form needed

[Richio]

I have one field in a from that I don't really want all users to see.

Without going down the security / password route has anyone got any neat tricks on hiding the field and only displaying if you know how. Ie a hidden button or something.

I did think of just putting it right at the bottom of the form so you have to scroll down to see it. (who would think of that !!)

The field needs to be a normal editable field.

Thanks

 

[yellow]

Not really sure if this is what you are after but you could trap a keypress for the form F9 or whatever. A key that isn't used in every day life. When the key is pressed make your field visible....Maybe!

 

[vangogh228]

Richio:

If you have a split database, you could customize the form on each PC to make the field invisible on those units you don't want to have see it.

If not split, you could create a second, identical form except WITH the field, and then create a macro that opens that form instead of the one that has the hidden field, using a keystroke combination to initiate. Only tell certain people what that key combo is.

Tom

 

[ghudson]

I prefer to use the DoubleClick event on a label or graphic to make an object visible. The odds of somebody accidently double left clicking a label or graphic should be very slim.

HTH

 

[The_Doc_Man]

I'm with GHudson. The last time I did something like that, I picked an obscure label on my form and gave it a double-click event. Then in that event, I flip-flopped the targeted control's .Visible property. Also that of its associated label.