AllowBuiltInToolbars Property

You can use the AllowBuiltInToolbars property to specify whether or not the user can display Microsoft Office Access 2007 built-in toolbars. For example, you can use the AllowBuiltInToolbars property to prevent a user from seeing an Access built-in toolbar within a database application.

Setting

The AllowBuiltInToolbars property uses the following settings.

Setting	Description
True (–1)	Allow built-in toolbars to be displayed.
False (0)	Don't allow built-in toolbars to be displayed.

The easiest way to set this property is by using the Allow Built-in Toolbars option on the Startup tab of the Access Options dialog box, available by clicking the Microsoft Office Button and then clicking Access Options. You can also set this property by using a macro or Visual Basic for Applications (VBA) code.

To set the AllowBuiltInToolbars 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.

Remarks

The user can modify built-in toolbars only when the AllowToolbarChanges property is set to True and the AllowBuiltInToolbars property is set to True.

If the AllowBuiltInToolbars property is set to False, you can't use the ShowToolbar action to display a built-in toolbar.

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