I’ve got an Access dB that I’m using for some data entry. The user asked to have a search combo bar added, with a hotkey combination to return you to the combo box.
I’ve got the combo box built, and now am trying to attach a hotkey. But I cannot find any instructions either in my manuals, or online. Is this even possible?
If yes, can someone tell me how?
If I understand you correctly, you have a combo box control on the data-entry form (and NOT on another pop-up form). If so, the proper way is to add an “accelerator key”:
The combo has an associated label. In the properties for this label, there is “caption”, which is simply the text for the label. Let’s say the combo is showing names, and the label caption is “Name”. Change this to “&Name”… the text will now be shown as “Name”, and Alt-N will shift the focus to the combo.
You know, sometimes fighting ignorance is something you can do on your own.
I found the answer in Beginning Access 2000 VBA by Robert Smith and David Sussman.
Click on the *LABEL * for the field you wish to hotkey. Right mouse-click to Properties. Choose Caption. Insert an ampersand (&) just prior to the letter you wish to hotkey. Close the Properties screen.
So if the Caption reads “Find A Name”, you would change the Caption to “&Find A Name” and it would look like “Find A Name”
And I see that K364 has the same solution…