Disable shortcut menu for page header only

[wallymeister]

I have a form that I want to disable the shortcut menu on the header section
only. This is the menu that brings up Layout View, Design View etc. I do
not want the user to be able to use this , but I do want them to be able to
use shortcut menu for the detail section. (Sorting, Filtering etc.)

Maybe by disabling each of the items on this menu individually, but I still
need help doing this.

Any help is mucho appreciated.
Wally

 

[Daryl S]

Wally -

I don't think the shortcut menu distinguishes between the header and detail
sections of the form. You can gray out the options for the form formats by
changing the properties of the form. Set the "Allow Datasheet View" property
to no, and that will gray it out in the shortcut menu. Save with PivotTable
and PivotChart views.

That's a start...

 

[wallymeister]

Daryl,
My form is Continuous Form view and it certainly does have a different
shortcut menu for the Header Section than the Detail Section. As I stated
earlier the Detail Setion has filtering and sorting items on it but the
Header Section has Design View, Form View and Layout View, with Cut, Copy And
Paste also. I set the Allow Layout View property to no and that eliminated
that one. Form View doesn't do anything so that doesn't matter, so the only
item I need to get rid of is the Design View item from this menu to keep
users from entering design view.

Thanks,
Wally

 

[Daryl S]

I think you can only get rid of the design view if you make an mde file or if
you put user security on database - maybe someone else knows otherwise?