• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1339
  • Last Modified:

Turn off Design View in VBA for Access 2007

I have an Access DB in which I truned off full menus.  Even with the menu options I turned off the user can still right click on the tab and has Design View as an option.  I would like to turn Design View off in VBA on the form Open event but there isn't an AllowDesignView = False command.  Is there another way to turn this option off?
0
marku24
Asked:
marku24
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
In Access 2003 (before Ribbons), this is easy to do because you can easily create your own custom right click menus, and apply them to any Form ... on the fly for that matter.  IF ... you are still using an MDB inside of the A2007 environment, you could still do this.  Is that by chance the case?

mx
0
 
marku24Author Commented:
No, I am using an accdb.  It seems like something that would be easy to turn off since you can turn on and off other views.  I thought I was just missing something.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You can ... turn off the Right Click menu for that form by setting the Form's ShortcutMenuBar property to No.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Another way would be to create an ACCDE ... which does not allow Design changes, thus  that menu item would be grayed out.

mx
0
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.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now