Show All

Designate a global menu bar or shortcut menu

By using your own global menu bar, you control what tasks users can perform in your Microsoft Access file by limiting and customizing the menus and commands that are available. The global menu bar replaces the built-in menu bar for all Microsoft Access windows, except where you've added a custom menu bar for a form or report. You also can define a global shortcut menu to replace built-in shortcut menus for datasheets, forms, form controls, and reports.

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

   To set a global menu bar, in the Menu Bar box, click the name of a custom menu bar from the current Access database or Access project, or click (default) to display the built-in menu bar.

   To set a global shortcut menu bar, in the Shortcut Menu Bar box, click the name of a custom shortcut menu from the current Access database or Access project, or click (default) to use the built-in shortcut menus.

3. To prevent users from switching to the built-in menu bar from the custom menu bar by pressing CTRL+F11, clear the Use Access Special Keys check box.

Notes

• Changes to this setting in the Startup dialog box won't take effect until the next time the Access file is opened.
• You can designate or change the global menu bar or shortcut menu in a Microsoft Visual Basic for Applications procedure by setting the MenuBar property or ShortcutMenuBar property of the Application object.