How to uncheck an option button?

[Guest]

All help appreciated - thanks in advance!

I've set up a form with various sets of grouped option buttons.

I would like the user to be able to UNCHECK their answer in a grouped set of
buttons and leave that group completely unchecked.

Although I've figured out how to have all option buttons unchecked on a new
form, I have not yet discovered how to totally UNCHECK an option (without
having to check another button in that group).

Thanks for your help

 

[fredg]

All help appreciated - thanks in advance!

I've set up a form with various sets of grouped option buttons.

I would like the user to be able to UNCHECK their answer in a grouped set of
buttons and leave that group completely unchecked.

Although I've figured out how to have all option buttons unchecked on a new
form, I have not yet discovered how to totally UNCHECK an option (without
having to check another button in that group).

Thanks for your help

You should add another button as you can set it's label to clear the
group value (and the label is a bigger target to click than the radio
button). Then set the OptionGroup AfterUpdate event to:

If Me![OptionGroupName] = X then
Me![OptionGroupName] = Null
End If

X being the number value assigned to that extra button.

You could also use the double-click event of the OptionGroup:

Me![OptionGroupName] = Null
but the user will have to double-click on the correct part of the
group (on it's border or it's attached label only).