Assigning a Keyboard shortcut to a button in an Access 2007 form

Question

Say I have a form on which a number of buttons exist. Everything works as it should when the buttons are clicked. How do I go about assigning keyboard shortcuts to my buttons so that Alt+A runs the action of Button A, Alt+B runs the action of button B etc.

seems like this would be trivial to do but I've not been able to see where I can set this.

Answer 1

If you wanted to set up a Global Keyborad Shortcut that would work no matter where you are in the current database then you can create a special macro called AutoKeys and set up like the following:

Note the special character used to represent special keys:

^ for Ctrl
+ for Shift
% for Alt

{F11} represents the F11 (function) Key

Answer 2

When creating the button use the ampersand before the letter you want to Alt+? in the Caption property.

Examples:

&File ---> File

&Edit ---> Edit

F&orge --> Forge

E&nough -> Enough