Want to bound several checkboxes to one field in Access

[steppinthrax]

I have a microsoft Access table. I make it into a forum in Access.

How I create several checkboxes in the forum. I want the Yes/NO result of those checkboxes to appear only in one field.

Example

Yes, No, Yes, Yes, Yes, No, should become

101110

If a user decides to uncheck a box right after finishing the entry into a record it should change ONLY that 1 to a 0 in that position of the string not add to the end of it.

So if the user decides to uncheck the first one to No the string should go to

001110

 

[KLin]

The easiest way to implement this is whenever a user changes any of the checkboxes, have it recalculate the value and update the field for that record.