If you want, you can bypass the key assignments (and many other startup options) by holding down the SHIFT key while you start the database.įind links to more information about creating macros in the See Also section. Type the letter in the Shortcut key box that you want to assign the macro to. Select the file that contains the macro from the Macros In drop down.

The new key assignments are available as soon as you save the macro group, and are in effect every time that you open the database. To assign the keyboard shortcut: Press the Macros button on the Developer or View Tab in the ribbon. In the Save As dialog box, under Macro Name, type AutoKeys. Repeat steps 3 and 4 for any other key assignments that you want to make.Ĭlick the Microsoft Office Button and then click Save, or press CTRL+S. Leave the Macro Name column blank for each succeeding action. To assign more than one action to the keyboard shortcut, add the additional actions that you want below the first action. For example, you can add a RunMacr o action that runs the Print Current Record macro when CTRL+P is pressed. In the Action column, add the action that you want the key or keyboard shortcut to perform. In the Macro Name column, press the key or keyboard shortcut to which you want to assign the action or set of actions.

On the Design tab, in the Show/Hide group, click Macro Names to display the Macro Name column. If this command is unavailable, click the arrow beneath either the Module or the Class Module button, and then click Macro. On the Create tab, in the Other group, click Macro. For example, CTRL+C is the keyboard shortcut for the Copy command if you assign this keyboard shortcut to a macro, Access will run the macro instead of the Copy command.

Note: If you assign an action to a keyboard shortcut that is already assigned to Access, the action that you assign to this keyboard shortcut replaces the Access key assignment.

View macro shortcut keys