Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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 Office button imageand 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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×