Ref: Checkboxes or radio buttons

[Guest]

In an effort to save disk space, I wanted to put a checkbox or radio button
next to specific items if the item applies for that person. If I had 10
checkboxes and five were TRUE, does Access save the checkbox info as part of
the record?

Thanks,
Les

 

[Brendan Reynolds]

In an effort to save disk space, I wanted to put a checkbox or radio
button
next to specific items if the item applies for that person. If I had 10
checkboxes and five were TRUE, does Access save the checkbox info as part
of
the record?

Thanks,
Les

If they are bound checkboxes (that is to say, the name of a field that forms
part of the record source of the form appears in the control source property
of each check box) then yes. Otherwise, no.

 

[Arvin Meyer [MVP]]

In addition to what Brendan offered, you could code the Current event of the
form to look at values in existing textboxes, and make a check box true or
false based upon those values (this won't work in a continuous form or
datasheet).

You could also build a table of UserIDs, a Boolean (yes/no) field, and a
QuestionID and join that in a query so the records will display in check
boxes.