option group check boxes

[mike]

is there a way to modify check boxes settings in an option group so i can
select multiple check boxes in the group?

 

[Allen Browne]

No.

If you have have multiple values for each value in your main table, this
needs to be stored in a related table.

 

[mike]

thx, i'm going w/ multiple check boxes.

another question: what's the default value to uncheck a check box?

 

[mike]

how do i set a field to yes/no based on whether or not a check box is checked
or unchecked?

 

[Allen Browne]

Mike, I don't think I understand your question.

To bind a check box on a form to a yes/no field in your table, set its
Control Source property.

To default a check box to no, set its Default Value property to:
0

Adding a stack of yes/no fields to a table is not a good design. See:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html