| title | keywords | f1_keywords | ms.prod | api_name | ms.assetid | ms.date | ||
|---|---|---|---|---|---|---|---|---|
DoCmd.ShowToolbar Method (Access) |
vbaac10.chm4185 |
|
access |
|
63663cc5-a591-c847-25c8-25777cf7806a |
06/08/2017 |
The ShowToolbar method carries out the ShowToolbar action in Visual Basic.
expression. ShowToolbar( ** ToolbarName, ** Show )
expression A variable that represents a DoCmd object.
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| ToolbarName | Required | Variant | A string expression that's the valid name of a custom toolbar you've created. If you run Visual Basic code containing the ShowToolbar method in a library database, Microsoft Access looks for the toolbar with this name first in the library database, then in the current database. |
| Show | Optional | AcShowToolbar | AnAcShowToolbar constant that specifies whether to display or hide the toolbar and in which views to display or hide it. The default value is acToolbarYes. |
You can use the ShowToolbar method to display or hide a custom toolbar.
If you want to show a particular toolbar on just one form or report, you can set the OnActivate property of the form or report to the name of a macro that contains a ShowToolbar action to show the toolbar. Then set the OnDeactivate property of the form or report to the name of a macro that contains a ShowToolbar action to hide the toolbar.