Right Click checkbox to uncheck?

[JubilantJeff]

I have a number of check boxes on a form with control sources of fields in a table. I want the user to be able to left-click on a checkbox to "check" it, and right-click on a checkbox to "uncheck" it. How would I go about doing this?



Thanks in advance for the help!

[TheShabz]

I'm not aware of an "OnRightClick" option in VBA. Perhaps there is an API someone made available on the interwebs. Google will be your friend on this.

[boblarson]

I'm confused. Why would you want it to be different from what it is now? You click the checkbox and it changes it from what it was (either checked or unchecked) to the opposite. It makes no sense to me why you would left click to select and right click to deselect when left clicking accomplishes both tasks.

[JubilantJeff]

I'm confused. Why would you want it to be different from what it is now? You click the checkbox and it changes it from what it was (either checked or unchecked) to the opposite. It makes no sense to me why you would left click to select and right click to deselect when left clicking accomplishes both tasks.

The checkbox is triple state. I would be fine if it was just double state. The way it is right now, the box starts at default, then goes to checked, then to unchecked. Considering there is a considerable delay between when you click to change it, and when you can click to change it again, it would be much faster to be able to right click. Also, there are over 10 checkboxes, so the time adds up quickly.

[boblarson]

So you WANT it to be TripleState?

[JubilantJeff]

Yea. I want it to be triple state.

[boblarson]

Well, I have to say, I'm stumped. I've tried everything I know to try and have not found a way to do it.

[JubilantJeff]

Alright. Thanks anyway. I appreciate the effort