Disable User From Hiding Columns

[mbreu996]

Is it possible to disable the user from hiding columns in datasheet view of a subform? More specifically, what I am referring to is when the user right clicks the header bar at the top of the datasheet and can access the hide columns option.

Thanks in advance, I have had nothing but very helpful advice from the kind people on these forums!

 

[John Big Booty]

You could set the Sub Form's Shortcut Menu property (found on the Other tab in design view) to No (false). This will however mean that you loose the menu that appears on Right Click. If you want to retain this menu but limit the options you will need to consider creating your own Pop Up or Shortcut Menu. See this link for a tutorial.

 

[mbreu996]

Awesome. Another case solved (and very quickly too).

Thanks John!