Disable Hide/Unhide columns

  • Thread starter Thread starter Akilah
  • Start date Start date
A

Akilah

Hi, in Access 2007 users can right click a subform in datasheet view and be
allowed to hide or unhide columns. Is there a way to disable the ability to
right click a subform or a way to stop users from hiding columns without
locking the subform? thanks.
 
Hi, in Access 2007 users can right click a subform in datasheet view and be
allowed to hide or unhide columns. Is there a way to disable the ability to
right click a subform or a way to stop users from hiding columns without
locking the subform? thanks.
Click to expand...

That's one of several reasons that I avoid using datasheet forms: they give
the user too much power and the developer too little!

You can prevent this problem by using a Continuous Form instead. It can be
made to look very much like a datasheet if you like that appearance, but it
doesn't let users mess themselves up in this way.
 
Back
Top