Option Group

B

bdehning

Is there a property for the option group that will allow a user to unselect a
choice after it is made?
 
F

fredg

Is there a property for the option group that will allow a user to unselect a
choice after it is made?

I don't quite understand this question. The option group gets it's
value from the selected button. If you then select a different button
it's value replaces the previously selected value automatically.

Perhaps you mean "How do I reset the option group value to Null after
having selected a value?"

If so, you can do this by having an extra button within the group.
Let's say your group has 3 options.
Add a 4th option button with a value of 4.
Give it a label that says "Clear Selection"

Code the OptionGroup's AfterUpdate event:
If Me![OptionGroupName] = 4 then
Me![OptionGroupName] = Null
End If
 
B

bdehning

Fred exactly what I needed.

Want to know in case choice was not needed or was in error as wrong option
group selected..

Thank You.

fredg said:
Is there a property for the option group that will allow a user to unselect a
choice after it is made?

I don't quite understand this question. The option group gets it's
value from the selected button. If you then select a different button
it's value replaces the previously selected value automatically.

Perhaps you mean "How do I reset the option group value to Null after
having selected a value?"

If so, you can do this by having an extra button within the group.
Let's say your group has 3 options.
Add a 4th option button with a value of 4.
Give it a label that says "Clear Selection"

Code the OptionGroup's AfterUpdate event:
If Me![OptionGroupName] = 4 then
Me![OptionGroupName] = Null
End If
 
Top