Microsoft KB Archive/120970

= ACC: How to Reset Toolbar Options =

Article ID: 120970

Article Last Modified on 6/24/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q120970



Novice: Requires knowledge of the user interface on single-user computers.



SUMMARY
The toolbars in Microsoft Access are fully customizable. This article describes how to reset the toolbars to their original settings so that only the toolbars that are appropriate for a given view are displayed.



MORE INFORMATION
The following example demonstrates a macro that you can use to reset the toolbars to their original settings:

  Create a macro called Reset Toolbars with the following action and arguments:

     Macro Name       Macro Actions --     Reset Toolbars   ShowToolbar

Reset Toolbars Actions --     ShowToolbar Toolbar Name: Database Show: Where Appropriate  Click the selector (the box to the left of the ShowToolbar action) to select the ShowToolbar action. On the Edit menu, click Copy. Click Paste on the Edit menu 19 times to create a total of 19 ShowToolbar actions in the macro.

NOTE: In version 2.0, click Paste a total of 18 times.  Change the Toolbar Name argument for the rest of the ShowToolbar actions to match the following table:

     ShowToolbar Action #   Toolbar Name Argument ---

In Microsoft Access version 7.0:

2                     Relationships 3                     Table Design 4                     Table Datasheet 5                     Query Design 6                     Query Datasheet 7                     Form Design 8                     Form View 9                     Filter/Sort 10                    Report Design 11                    Print Preview 12                    Toolbox 13                    Formatting (Form/Report Design) 14                    Formatting (Datasheet) 15                    Macro 16                    Visual Basic 17                    Microsoft 18                    Utility 1 19                    Utility 2

In version 2.0:

2                     Relationships 3                     Table Design 4                     Table Datasheet 5                     Query Design 6                     Query Datasheet 7                     Form Design 8                     Form View 9                     Filter/Sort 10                    Report Design 11                    Print Preview 12                    Toolbox 13                    Palette 14                    Macro 15                    Module 16                    Microsoft 17                    Utility 1 18                    Utility 2

NOTE: Setting the Microsoft toolbar to Where Appropriate will cause it to be shown in all views; therefore, you may want to set it to No. </li> Run the macro. All the toolbars will be reset to their original settings.</li></ol>

<div class="references_section">