Option group radio buttons

[sharonir22]

hi
I've set an option group on my form with yes/no option, Yes being the default option. for some reason, when the form is displayed, the radio button of the default option appears unchosen (not blue)
has anyone seen this problem before? I would appreciate a solution

[ItsMe]

In older versions of Access all of this was managed via the properties of the option group. I have not tried building any in 2013 yet. Have you tried using a MsgBox in the form's on load event to see what the default value is?

The option group default value is not the same as the default value of a radio button. Use your cursor to select the outside edge of your option group before checking the properties and also, check the name of your option group.

[Missinglinq]

As ItsMe posted, you have to control this through the Option Group, not using the individual Radio Buttons. If you used the Option Group Wizard to create the OG, it asked you to enter a Label for each selection. If you entered them as

Yes
No

in that order, then when Yes is ticked, the OG's Value is 1, when No is ticked, the OG's Value is 2.

To set the Default for the OG to 'No,' as you need to, you need to enter 2 as the Default.

1. Right Click on the OG's Frame, which, unless you changed its name, will be something like FrameX, where X is a number
2. Click on Properties
3. Click on Data Tab
4. Set the Default Property to 2

If you assigned the selections in reverse, to

No
Yes

instead of

Yes
No

as given above, you need to set the Default, in the Property Pane to 1, instead of 2.

When you refer, in VBA code, to the selection made in the OG, you'd use code something like this

Select Case Me.FrameX

 Case 1

  'What to do if the first control was selected

 Case 2

  'What to do if the second control was selected 

End Select

Linq ;0)>

[sharonir22]

So after investigating I noticed the 1 value is being stored in the table as -1. So i changed the button value to -1. Worked for me.