Where is check box data stored?

[JeffG3209]

Well, i spent a rather large part of the day revamping my current design. I was going to create a 5 drop down boxes on a form with 5 variables in each box. The object is to select a method of contact with clients. Example: Phone, Email, In Person, Social Media, etc. The reason for five boxes is the result could be more than one method of contact. Example: Email & Phone



I thought, hey, what's up with check boxes? They would be much simpler and an easier path. So I added one. I thought ok, I will save my progress on the form and take a look at my table to see where the data is stored. I have read that the output for a check box is either a -1 or a 0 (yes/no).

So I went digging. I cant find the data for the check boxes, but it is being saved to the record. That isn't going to work for me because I am wired to need to know how and why

I'm sure it is pretty simple, anyone care to enlighten me?

[June7]

What do you mean 'cant find the data for the check boxes'? You say it is saved to record so you have found the data.

You are using checkboxes as part of an Option Group? Checking a box sets value of the Option Group. It is the Option Group control that is bound to field and that value is saved.

[JeffG3209]

It is the Option Group control that is bound to field and that value is saved.

I'm always learning. I figured that the check box would have a field on a table for each record. This is not the case, where is the option group data stored? Is this something that takes place behind the scenes of access?

[June7]

If checkboxes or option buttons are not part of an Option Group then each would be bound to a field of table and save their individual value. As part of an Option Group the checkbox/option button does not have an individual ControlSource property - the Option Group control has the ControlSource property. Selection of checkbox/button sets the value of the Option Group control. This value is saved to the field in table, probably a text or number datatype. Nothing is 'behind the scenes', to save value some control must be bound to a field.