Troubleshoot toolbars

Microsoft Office Access 2003

If all the built-in toolbars and some of the built-in menus have disappeared from all views, you may need to change the settings in the Startup dialog box or temporarily bypass its settings. You should also check the Allow Showing/Hiding and Show On Toolbars Menu property settings of the individual toolbar in the Customize dialog box (View menu, Toolbars command).

ShowTo change the settings

Click Startup on the Tools menu, and then click Allow Built-in Toolbars to display all the built-in toolbars, and click Allow Full Menus to display all the built-in menus. Close the Microsoft Access data file, and then reopen it.

If you're still missing some menus, they may have been removed from the menu bar. You can re-add specific built-in menus to the menu bar.

ShowTo temporarily bypass the settings in the Startup dialog box

You can temporarily bypass all the settings specified in the Startup dialog box instead of resetting the options. Hold down the bypass key (the SHIFT key) while you open the database.

ShowI want to return built-in toolbars that came with Microsoft Access to their original settings.

Do one or more of the following:

ShowReset all default settings for a built-in toolbar or menu bar to display either the original buttons or the menus and commands and to restore their original property settings.

Microsoft Access will also restore the original property settings for the toolbar or menu bar itself, including restoring its screen location and size, and hiding or showing the bar.

  1. On the View menu, point to Toolbars, and then click Customize.
  2. On the Toolbars tab, click Properties.
  3. In the Selected Toolbar box, select the name of the toolbar or menu bar you want to reset default settings for.
  4. Click the Restore Defaults button.

The Restore Defaults button isn't available until Microsoft Access detects that the selected built-in toolbar or menu bar has been modified.

ShowRestore a menu's original appearance

  1. On the View menu, point to Toolbars, and then click Customize.
  2. With the Customize dialog box open, right-click the menu you want to restore, and then click Reset on the shortcut menu.
  3. On the Customize dialog box, click Close.

Note  The Reset command restores the built-in menu to its original images, commands, and submenus.

ShowRestore original buttons, menus, and commands on a built-in toolbar, menu bar, or shortcut menu without changing other properties of the toolbar or menu bar (such as the screen location and size).

  1. On the View menu, point to Toolbars, and then click Customize.
  2. Click the Toolbars tab.
  3. In the Toolbars box, click the name of the toolbar you want to restore.
  4. Click Reset.

Notes

  • You cannot reset a custom toolbar.
  • As you work with Microsoft Office, the menus and toolbars are personalized to show the commands that you use most often if you have cleared the Always show full menus box on the Options tab in the Customize dialog box. If you want, you can return the toolbar and menu display to the state it was in when you first started using Office.

ShowRestore how an individual toolbar button or menu command originally appeared (except in an individual shortcut menu)

  1. Make sure the toolbar you want to change is visible.

    ShowHow?

    1. On the View menu, point to Toolbars.
    2. Do one of the following:
      • If the toolbar name is listed, click the toolbar name.
      • If the toolbar name is not listed:
        1. Click Customize.
        2. In the Customize dialog box, click the Toolbars tab, and then double-click the toolbar you want to show.
  2. On the View menu, point to Toolbars, and then click Customize.
  3. With the Customize dialog box open, do one of the following:
    • To restore a toolbar button, right-click the button, and then click Reset on the shortcut menu.
    • To restore a menu command, click the menu that contains the command, right-click the command, and then click Reset on the shortcut menu.

Notes

  • The Reset command restores the built-in toolbar button or menu command to its original image, name, and command.
  • The Reset command isn't available for a button that displays a list when clicked.

ShowShow default toolbar buttons and menu commands

  1. On the View menu, point to Toolbars, and then click Customize.
  2. Click the Options tab.
  3. Click Reset my usage data.

Notes

  • The Reset my usage data button affects the buttons shown on a built-in toolbar only if it is not wide enough to display all the buttons. It affects the menu commands shown on the short version of built-in menus only if you have the Always show full menus box cleared on the Options tab in the Customize dialog box.
  • The Reset my usage data button affects only the toolbar buttons and menu commands of the Microsoft Office program in which the button is clicked.
  • The Reset my usage data button does not change the location of toolbars, does not remove any buttons or commands you've added by using the Customize dialog box, and does not add buttons or commands you've deleted.

ShowI'm having trouble either pasting or resetting an icon image onto a menu or toolbar.

The command on which the icon appears may be set to a style that doesn't allow images. To complete the operation you were trying to perform, first change the command's style.

  1. On the View menu, point to Toolbars, and then click Customize.
  2. If it isn't already displayed, show the toolbar or menu containing the command whose style you want to change.

    ShowHow?

    1. On the View menu, point to Toolbars.
    2. Do one of the following:
      • If the toolbar name is listed, click the toolbar name.
      • If the toolbar name is not listed:
        1. Click Customize.
        2. In the Customize dialog box, click the Toolbars tab, and then double-click the toolbar you want to show.
  3. Leave the Customize dialog box open. On the toolbar or menu, right-click the command whose style you want to change.
  4. On the shortcut menu, click Default Style or Image And Text.

Note  On a menu, the Default Style setting displays a command's text and associated icon image (if it has one). On a toolbar or menu bar, the Default Style setting displays just the icon image.

ShowI can't customize a toolbar.

If you are unable to customize a toolbar, make sure that the Allow Customizing check box in the Toolbar Properties dialog box is selected.

If the Toolbars command on the View menu is disabled, you might need to change the settings in the Startup dialog box or temporarily bypass its settings.

ShowTo change the settings

  • On the Tools menu, click Startup, and select the Allow Toolbar/Menu Changes check box. Close the database, and then reopen it.

ShowTo temporarily bypass the settings in the Startup dialog box

You can temporarily bypass all the settings specified in the Startup dialog box instead of resetting the options. Hold down the bypass key (the SHIFT key) while you open the database.

ShowI can't see my entire toolbar on the screen.

Some buttons may not appear on the toolbar because there is not enough room to display them. Click More Buttons Button image at the end of the toolbar to see a list of additional buttons.

There may not be enough room to display all of the buttons because the toolbar is on the same row as another toolbar. To see more buttons, you can resize the toolbar or move the toolbar to its own row or to another location. To move the toolbar, click on the handle at the left end of the toolbar and drag the toolbar to the desired location on the screen.

ShowI can't show or hide a toolbar, menu bar, or shortcut menu.

If you are unable to show or hide a toolbar, menu bar, or shortcut menu, make sure that the Allow Showing/Hiding check box in the Toolbar Properties dialog box is selected.

ShowI can't find a menu command, toolbar button, or dialog box option.

The menu might not be expanded    If arrows Double arrows pointing down appear at the bottom of the menu, the menu item might be available on the expanded menu. Click the arrows , and then click the command you want. You can also double-click the menu to expand it.

There might not be enough room to display all the buttons    If the toolbar is on the same row as another toolbar, there might not be enough room to display all the buttons. Click Toolbar Options Button image, and then click the button you want.

You might have a different language setting    The command or control doesn't appear if you don't have editing enabled for the language that the command or control applies to. You need to enable editing for the language you want to work with.

The Microsoft Office program you're using may not be maximized    Some toolbar buttons may be hidden if your program window is not maximized. Click the Maximize Button image button to enlarge the program window to its fullest extent.

ShowI created a custom toolbar and shared it with another person, but it looks different on their computer.

The buttons and commands that you share with another person are always available, but whether or not they appear on the short version of the menu, or on the toolbar when there isn't enough room to display all the buttons, depends on the individual menu and toolbar settings for that person.

Microsoft Office stores the commands and buttons you've used frequently and recently as your personal menu and toolbar settings. When the Always show full menus check box is cleared (Toolbar Options arrow Toolbar Options arrow, Add or Remove buttons, Customize dialog box, Options tab), these personalized settings affect the commands that appear on each menu. Additionally, if there isn't enough room on a toolbar to display all the buttons (such as when you position a toolbar on the same row as another toolbar), personalized settings affect which buttons do appear.