Set checkbox values

[SKraljica]

Hello,

i have many chexboxes at mine form. Over 300.
In mostly of cases dont be checked, but i should set values for all checboxes to 1 if is checked and 0 if is not.
So, i started one by one, like you can see an image.


My question is: Is there any way to say in one place, if is any checkbox at the form ckecked value is 1, and if is not, value is 0 ?

[Bob Fitz]

You could write some code to loop through the forms control and IF it is a Check box THEN set its value.
Is this an unbound form. AFAIK you can't have more than, I think the figure is 256, fields in a table.
I can't imagine why you would need a form with more than 300 controls of any type.

[SKraljica]

All field is unbound.
They make strings of four or five each.
Individual groups are entered in the same field of the table, but as a new row.
The table has a total of 10 fields

[Bob Fitz]

Can you post a copy of the db. I've never seen access used like that.

[Missinglinq]

And a plain language explanation of your objective here would probably help, too.

I think Bob may be right in that Access may not be really be the appropriate tool for this.

Linq ;0)>