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

ms-access ms-access-2007
Istari picture Istari · May 5, 2009 · Viewed 24.5k times · Source

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

NickSentowski picture NickSentowski · May 5, 2009

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

Related questions

Now() function with time trim

So the function =Now()....is there a way I can use this and only get the date, not the time? or is there just a function for this idea?

Read More
A select query selecting a select statement

I don't even know if I am doing this query the right way. There is a Sandwiches table that has some 7 fields and 2 of them are comboboxes (Type and Bread). So I made a query that combines all of the …

Read More
Determine whether a Access checkbox is checked or not

Such a simple question, but I cannot find the answer (Google, MS help, SO): How can I check by VBA whether an unbound checkbox on an Access form is checked by the user or not? Can't find the right property. …

Read More