<div>
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. &nbsp;IF ... you are still using an MDB inside of the A2007 environment, you could still do this. &nbsp;Is that by chance the case?<br />
<br />
mx
</div>


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

<div>
No, I am using an accdb. &nbsp;It seems like something that would be easy to turn off since you can turn on and off other views. &nbsp;I thought I was just missing something.
</div>


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.

<div>
Another way would be to create an ACCDE ... which does not allow Design changes, thus &nbsp;that menu item would be grayed out.<br />
<br />
mx
</div>


Another way would be to create an ACCDE ... which does not allow Design changes, thus  that menu item would be grayed out.

mx

<div>
<div class="content wysiwyg-content">
I have an Access DB in which I truned off full menus. &nbsp;Even with the menu options I turned off the user can still right click on the tab and has Design View as an option. &nbsp;I would like to turn Design View off in VBA on the form Open event but there isn't an AllowDesignView = False command. &nbsp;Is there another way to turn this option off?
</div>
</div>


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?

Turn off Design View in VBA for Access 2007

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.