How to Add Keyboard Shortcuts MS Access

Quick summary

Adding keyboard shortcuts in MS Access lets users navigate forms and reports faster by assigning an ampersand shortcut key to any control's Caption property in Design View. This step-by-step process requires no coding — just a simple character change in the Property Sheet.

Steps

1. Right-click the form or report and select 'Design View' to enter edit mode.
2. Select the control you want to assign a keyboard shortcut to.
3. In the Property Sheet, locate the 'Caption' property for that control.
4. Add an ampersand (&) before the letter you want to use as the shortcut key in the Caption value.
5. Open the form or report in 'Form View' and press the keyboard shortcut to verify it works correctly.
6. You have successfully added a keyboard shortcut to a control in MS Access.