Disable Hide/Unhide columns

[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.

 

[John W. Vinson]

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.

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.