• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1333
  • 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 MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
Another way would be to create an ACCDE ... which does not allow Design changes, thus  that menu item would be grayed out.

mx
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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