[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 763
  • Last Modified:

Key Strokes for Tick Box and Combo Drop Down

Can an expert advise if there are keystrokes when being in a form for:

1)  placing a tick in a tick box and reversing it
2)  when you tab into a combo field to drop the selection box down

If there are no keys strokes for this, can you give me the vba to asign to the controls.

Many thanks
0
PeterWhitts
Asked:
PeterWhitts
2 Solutions
 
EMCITCommented:
1) You can use the tab key to move between controls. When you enter, say, an option group you can use the arrow       keys to move between the selections and the enter key to select.

2) In the Got Focus Event: Me!ComboBoxName.Dropdown

0
 
Eric ShermanAccountant/DeveloperCommented:
>>>>>>>1)  placing a tick in a tick box and reversing it<<<<<<<<<<<

Tab to to control and press the Space Bar.  This will toggle the tick box on and off.

ET
0
 
PeterWhittsAuthor Commented:
spacebar works fine but the arrow keys only seem to select another record.....EMCIT can you be a bit more specific in what you mean. Thanks
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
PeterWhittsAuthor Commented:
Or do you mean that I need the vba as well as the key strokes to make it work?
0
 
Eric ShermanAccountant/DeveloperCommented:
Peter ...

EMCIT suggestion is correct and the way I would handle that portion of your question.

He is saying, for the Got Focus Event of your drop down box enter ...

Me.YourComBoxName.Dropdown

ET
0
 
jefftwilleyCommented:
I think what you're asking is summed up this way

In the Got Focus Event: Me!ComboBoxName.Dropdown

This makes the combo box dropdown as soon as it is reached, like a web based drop down does. Instead of having to hit that little down arrow on the combo box to make the list part drop down.

once it's set up that way then you can do your keystroke thing.

tab tab tab (found dropdownbox) arrowdown arrowdown arrowdown (found item I want) enterkey

J
0
 
PeterWhittsAuthor Commented:
Thanks for that...very useful even though no straight key stroke for combo box dropdown (unless using vba).
0
 
PeterWhittsAuthor Commented:
Have since learnt that the key stroke for dropping down a combo box on entry is     F4
0
 
Eric ShermanAccountant/DeveloperCommented:
Peter ...

Sorry, I mis-read your question after I reviewed the other comments.  I actually thought you were looking for the VBA code to automatically drop down your combo box.

ET
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now