On ctrl-click event?

[JamesMcS]

Hi! Just an academic one at the moment - I've got a series of checkboxes, that between them build a filter for a form. What I'm wondering is, is there a way to have an 'on ctrl-click' type event, that would deselect all the other checkboxes except the one the user has clicked on.

I know option groups allow you to select one value, but I wanted a bit of flexibility for the user - to be able to check as many boxes as they like, but if they only want one checked, not to have to manually uncheck all the others.

 

[DCrake]

Have a radar button underneath your series of check boxes that says....

Allow multiple selections.

Then on the On Click event of any check box first eval the radar value and if set to False run some code that set all the other checkboxes to false, else ignore.

 

[JamesMcS]

Radar? Google suggested 'radio'

I thought of this kind of method, I just wondered if there was a cunning way to get something in the on click like "If ctrl was being held down when on click event went off, ...." But that would be TOTALLY beyond my minimal skill set

 

[DCrake]

Radar - Radio who cares you know which control I mean

Using the Ctrl method would involve the user using both hands. One to hold down the Ctrl key and one to click the mouse. Bad use of resources and needs to be done in all instances. Having a default option is far more productive.

 

[JamesMcS]

Yep, always need one hand free.... for tea, I mean

Ever heard that tune 'Radio Love'? Oh hang on.... but you know what I mean

Thanks for your help DC!

 

[gemma-the-husky]

there is a dbl-click event

reading anything else is possible, but you need to interrogate key presses, and such like to identify what has been pressed, whereas dble-click is always there.

not quite the same thing, but the autokeys macros also let you use ctrl+key to do any rtask - you could use one of those. In fact, autokey macros are the only thing that you cannot do in VBA.

 

[JamesMcS]

Yeah, problem with double click on a text box is it's either on and back to off or the other way around. I reckon autokeys would be the way to go - but I've got plenty to be getting on with for now!

Thanks for your insight dudes! Time to smoke.