Yes/No Checkboxes

[Txlonghorn76]

I have a table that has check boxes where the data type is yes/no. How can I
change the table field design so that if the boxes are not checked, a box
does not appear at all? Any siggestion n what other ways I can re-design the
table to make it easier for the end user?

 

[Allen Browne]

If you have lots of yes/no fields in the table, chances are it does need to
be redesigned so you have a related table with many *records* rather than a
wide table with many *fields*.

For details, see:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html

In a report, it is possible to not show the unchecked boxes by simulating
them with a text box. Details in:
Format Check boxes on reports
at:
http://allenbrowne.com/ser-52.html

 

[Txlonghorn76]

i have an Infopath form that populates the Acccess database. There is a list
of documents that the user has to check off. What options do I have?

 

[Allen Browne]

Perhaps someone who uses InfoPath can comment on the best interface here. If
not, an infopath group might help.

From the database point of view, the crucial thing is to think clearly about
2 different things:
a) how to normalize the data, i.e. the structure of one-to-many relations.
This is an Access question, and absolutely crucial to queryability.

b) how to interface the data. In Access, this has to do with forms and
reports for entering and viewing output. I'm not sure how InfoPath forms are
bound to databases.

If you want to read further about normalization, beyond the couple of
examples I gave you, Jeff Conrad has a bunch of links here:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101