Shortcut menu in Access 2007 Forms

Is there any way of enabling the shortcut menu for fields within a Form, for Sorting and Searching, whilst disabling the shortcut menu from the Title Bar of the Form for Saving, Closing and Design View?
Who is Participating?
Henry_HarrisConnect With a Mentor Author Commented:
Thnaks for the last reply. Yes I have looked at the article and it is a way to go. I also clicked the comment was helpful button. I hope this worked
You have to build your own tool bar to be used in place of the normal forms tool bar when that form is called.  Read all you can find on the form property Toolbar - especially Help in both the Database and VB Editor windows.
Chuck WoodCommented:
Here is an article on creating shortcut menus in Access that might help: 
-chuck wood
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:

"ShortCut Menu" typical refers to the "Right click menu".

If this is what you are referring to, then you can only assign specific Shortcut menus to the individual Forms, not controls on a form.

<whilst disabling the shortcut menu from the Title Bar of the Form for Saving, Closing and Design View?>
Again, I think you have your terms confused.
There is no "ShortCut" menu in the title bar.
What is in the Title Bar are known as "Drop Down Menus"

What you are asking for is certainly do-able.
You have to create a Custom *Toolbar*, (Using the "Built in Menus" Option in the "Commands" tab of the Customize Dialg box) and simply not include what you don't want.
Then you have to change the properties of this toolbar to make it a Menubar.
Then set that Menubar as the Default in the Access StartUp Options.

See this links for detailed info on creating Toolbars/Menubars:


Henry_HarrisAuthor Commented:
Thanks for your replies.

Yes I do mean the right-click menus. It would be nice to prevent the Save, Close and Views menu from the title bar of the Form whilst still allowing the Sort and Search menu from any individual field. I think that it can be achieved but the other way round by manipulating the Shortcut Menu Bar property.
Chuck WoodConnect With a Mentor Commented:
Did you read the article on How to: Create a Shortcut Menu for a Form, Form Control, or Report? 
-chuck wood
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.