Prevent or allow the changing of toolbars, buttons, or commands

Microsoft Office Access 2003

ShowPrevent or allow adding, moving, or removing specific toolbars, menu bars, or shortcut menus, and setting properties for buttons, commands, or menus

  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, menu bar, or custom shortcut menu you want to set properties for.
  4. Select or clear the Allow Customizing box.

ShowPrevent or allow movement of specific toolbars or menu bars

  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 set properties for.
  4. Select or clear the Allow Moving check box.

Note  This setting is not affected by the Allow Toolbar/Menu Changes setting in the Startup dialog box (Tools menu).

ShowPrevent or allow resizing of specific floating toolbars or menu bars

You can resize floating toolbars or menu bars.

  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 set properties for.
  4. Select or clear the Allow Resizing check box.

Note  This setting is not affected by the Allow Toolbar/Menu Changes setting in the Startup dialog box (Tools menu).

ShowPrevent or allow showing and hiding specific toolbars or menu bars

By default, you can show and hide custom toolbars and menu bars by choosing them from the submenu you see when you point to Toolbars on the View menu or from the shortcut menu you get when you right-click on a toolbar button or menu. You can prevent users from doing this by removing the names of the toolbars or menu bars from these menus.

  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 set properties for.
  4. Do one of the following:
    • To show a toolbar, select the Allow Showing/Hiding box and Show On Toolbars Menu check boxes.
    • To hide a toolbar, clear the Allow Showing/Hiding box and Show On Toolbars Menu check boxes.

      If you clear this option, make sure you clear both options. If you don't clear the Show On Toolbars Menu check box, the toolbar or menu bar will appear on the menu, but you won't be able to select it.

ShowPrevent or allow specific toolbar or menu bar docking

You can prevent or allow vertical, horizontal, or all docking of toolbars.

  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 set properties for.
  4. In the Docking box, click the setting you want to use.

Notes

  • For any setting other than Can't Change, make sure that the Allow Moving check box is also selected.
  • This setting is not affected by the Allow Toolbar/Menu Changes setting in the Startup dialog box (Tools menu).

ShowPrevent or allow changes to some or all toolbars, buttons, or commands

ShowPrevent or allow changes to all toolbars and command bars

You can control whether users are able to change any built-in or custom toolbars and menu bars in a Microsoft Access file.

  1. If you also want to prevent users from moving, sizing, or docking toolbars or menu bars, you must first set the appropriate properties in the Customize dialog box for each toolbar or menu bar in your application.
  2. On the Tools menu, click Startup.
  3. Clear or select the Allow Toolbar/Menu Changes check box.

Notes

  • Changes to these settings in the Startup dialog box won't take effect until the next time the Access file is opened.
  • This option does not affect toolbars for PivotTable lists or spreadsheets on a data access page.

ShowControl whether some or all of the built-in menus are displayed

If the Microsoft Access file you're creating provides the user access to the built-in menus, you can choose to display only a predefined subset of the menus. That way, you can hide menus, such as View and Insert, that would enable a user to access the Design view of objects in your Access database or Access project and to change their design.

  1. On the Tools menu, click Startup.
  2. Clear or select the Allow Full Menus check box.

Note  Changes to these settings in the Startup dialog box won't take effect until the next time the Access file is opened.

ShowControl the display of all built-in toolbars and menus

You can control whether built-in toolbars, the built-in menu bar, or built-in shortcut menus are available in a Microsoft Access file.

  1. On the Tools menu, click Startup.
  2. Do one or more of the following:

    To prevent or allow access to all built-in toolbars, clear or select the Allow Built-in Toolbars check box.

    To prevent or allow access to built-in shortcut menus, clear or select the Allow Default Shortcut Menus check box.

    To prevent or allow switching between the custom menu bar and the built-in menu bar by pressing CTRL+F11, clear or select the Use Access Special Keys check box.

Notes

  • Changes to these settings in the Startup dialog box won't take effect until the next time the Access file is opened.
  • Clearing or selecting the Allow Built-in Toolbars check box does not affect toolbars for PivotTable lists or spreadsheets on a data access page.