AllowFullMenus Property

You can use the AllowFullMenus property to specify whether or not full Microsoft Office Access 2007 built-in menus will be available when the application database opens. For example, you can use the AllowFullMenus property to disable menu items that give users the ability to modify table, form, query, or report structures.


The AllowFullMenus property uses the following settings.



True (–1)

Display the full built-in menus at startup.

False (0)

Don't display full built-in menus at startup.

The easiest way to set this property is by using the Allow Full Menus option on the Startup tab of the Application Settings dialog box, available by clicking Access Options on the File menu. You can also set this property by using a macro or Visual Basic for Applications (VBA) code.

To set the AllowFullMenus property by using a macro or Visual Basic for Applications (VBA) code, you must first either set the property in the Startup dialog box once or create the property in the following ways:

  • In a Microsoft Access database (.mdb or .accdb), you can add it by using the CreateProperty method and append it to the Properties collection of the Database object.

  • In a Microsoft Access project (.adp), you can add it to the AccessObjectProperties collection of the CurrentProject object by using the Add method.


If you set this property to False, a predefined subset of the full built-in menus is displayed in your database. This set of menus doesn't include menus and commands that enable users to change the design of database objects.

Setting this property to False also disables the toolbar buttons that correspond to the disabled menu items. However, shortcut menus aren't affected (you can still change some design features by using shortcut menu commands). If you don't want users to have access to the commands on the shortcut menus, you can set the AllowShortcutMenus property to False.

This property's setting doesn't take effect until the next time the database opens.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!