How to remove "Design view"-option from Form's Pop-up menu?

Posted on 2003-03-13
Medium Priority
Last Modified: 2012-06-27
Hi there,

If user is viewing a form and right cliks on it, Access will open an 'pop-up menu' (I don't know what is it called in English version) with options:
-Design View
-Datasheet View
-Filter by Form
-Filter or Sort
-Show All Records

Now I want to get rid of that "Design View" option. From form's design view I can set Allow Filtering to 'no' and that greys out filtering options. I just can't figure out how to get rid of that "design view". I have tried deleting all CommandBars and everything and all I got was all other ComBars were deleted, except that one. By deleting that option I wan't to prevent user access to form design view and from there into the query builder. I'm running Access 97.

Any ideas anyone?
Question by:justina
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
LVL 41

Accepted Solution

shanesuebsahakarn earned 200 total points
ID: 8129077
You can create a custom shortcut menu without the option and set the form's Shortcut Menu property to the one you've just created. Alternatively, click Tools->Startup and untick Allow Default Shortcut Menus (but this will remove all right-click shortcuts).

Author Comment

ID: 8129089
Never mind, I found the answer by myself...

From form properties, select "Quick menu" (or something similar in english) and set it to "No".

And I have worked 2 hours to find that out...

LVL 18

Expert Comment

ID: 8129093
How about converting it to an MDE?  Be sure to make a back up first!
How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.


Author Comment

ID: 8129101
You were faster and also brought up few other options, so you will be rewarded. =)

LVL 41

Expert Comment

ID: 8129118
Thanks :-)
LVL 18

Expert Comment

ID: 8129146
Man!  I'll never catch up in points!

'The slow code never catches the worm'

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question