Option button selection not filled in

I'm designing a form in Access. However, when I run the form, when I select an option button, it is not filled in. So it is not clear to the user that he has actually made a selection.
nmicheleAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Robert ShermanOwnerCommented:
It's not clear in your question whether this is happening for all option buttons or just a particular instance.   If you create a new, blank form in design mode, then add an unbound option button to the form, when you run the form are you able to click the option button and have it turn "on" and "off" as you click it?

If an option button on a form is not getting "filled in" when you click on it, it might indicate that the button is tied to a field that can not be changed for some reason.   Check the control source for the option button(s) that aren't working.   Do they point to fields that are editable in the form's record source?
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If your buttons are part of an Option Group, you'll have to check the ControlSource of the Option Group. Buttons in an Option Group don't have a Control Source.
0
nmicheleAuthor Commented:
Hi Robert and Scott,

Thank you for your responses.

To clarify further, the Control Source is a field with data type 'Yes/No'.

This is happening for all option buttons in the Option Group.

As far as I can tell, the control source is editable. The label associated with the option button has a dotted line around it when the user clicks on it. Also, the value is stored correctly in the table when the user clicks an option, However the Option button is not filled in.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Option Groups store values as a Number, and each "item" in the group would have to be assigned an "Option Value" appropriate for the Option Group value.

Since you're using Yes/No, you will have to set the Option Value of your button to 0 or -1.

0 = False
-1 = True
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nmicheleAuthor Commented:
Thank you, guys!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.