check boxes in option groups

[Bill H.]

I've set up a few option groups on a form using checkboxes. The dataype for
the checkboxes is Yes/No.

I noticed that when I'm on a new record, the boxes are grayed out. That's
good. But as soon as I check one of the boxes, they all become active
(un-grayed out) and all default to the No box checked. That's not good.

How do I set the default of the Yes/No option group to be Null?

Or another way to fix?

On another tab of the form, I have some radio buttons in some option groups.
When I click on one buttion in an option group, all the other option group
buttons become active, but at least nothing is selected.

 

[Duane Hookom]

Did you review the default properties of the table and the controls?

 

[Bill H.]

The default value for the fields in the table are nothing (blank) and the
default for the control on the from is likewise blank.

Did you review the default properties of the table and the controls?

 

[Duane Hookom]

If these are in an option group then this is expected behavior.

--
Duane Hookom
MS Access MVP

The default value for the fields in the table are nothing (blank) and the
default for the control on the from is likewise blank.

 

[Bill H.]

They are in an option group, but I don't like the behavior.

Can I keep them in the option group yet change the behavior?

--Bill

 

[Duane Hookom]

Can you tell us what exactly you are attempting to do? This doesn't make
much sense to me as a user interface.