Enterprise Software

Add shortcut menus to your Access forms

In Access, you can provide users with customized menus that are tailored to their needs. Here's how to create a shortcut menu.

While Access does provide standard shortcut menus for your form controls, you can provide users with customized menus that are tailored to their needs. For example, suppose you want users to be able to sort an Employees data form in ascending or descending order by the employees' last names. To create the shortcut menu, follow these steps:

  1. Select View | Toolbars | Customize.
  2. On Toolbars Tab, select New button.
  3. Enter Alpha Sort.
  4. Click Properties.
  5. Select Popup from Type drop-down list.
  6. Click Close.
  7. Scroll to and select Shortcut Menu under Toolbars.
  8. Click Custom from Shortcut menus toolbar and select Alpha Sort.
  9. Click Commands tab in Customize Dialog.
  10. Click Records under Categories list.
  11. Click and drag the Sort Ascending command to the Alpha Sort Shortcut menu.
  12. Click and drag the Sort Descending command to the Alpha Sort Shortcut menu.
  13. Click the Close button in the Customize Dialog box.

To assign the Alpha Sort shortcut menu to the Last Name field, open the form in Design view, right-click the field, and select properties. Under the Other tab, click in the Shortcut menu bar box and select Alpha Sort from the drop-down list.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox