Show check boxes which arn't blank, hide check boxes which are bla

[Accessorise]

I have a form that has 103 Aircraft boxes. Applicants must tick the
checkboxes beside the aircraft they are endorsed in. Although it can be
filled in easily the information is not easily emailed to others and it would
be better if only the aircraft they are endorsed in were listed rather than
all the aircraft and all the check boxes. I have tried writing a report but
there are too many fields. I have tried looking at other threads such as
that posted on 11/6/05 referring to 35 check boxes but I can't get their
suggestions to work. I'm not fantastic on code so if you give me code you
will have to tell me all the steps.

 

[Allen Browne]

There are 2 important database concepts here:
a) how to store the data correctly (normalized)
b) how to interface the data for the user.

If you have 103 yes/no fields in your table, you do not have a normalized
design. Consequently, it's going to be difficult to query, and very
difficult to maintain. For example, to add another type of aircraft, you
have to add another yes/no field to your table, and then change all the
queries, forms, and reports. For an example of a much better design, see:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html

Once you have the data stored correctly, you can work on the interface. You
won't have to add that many check boxes to your report.

It is possible to set up a report that simulates unchecked boxes and leaves
blank space rather than unchecked boxes. This will also export correctly.
Details in:
Format Check boxes on reports: size, color, unbox, conditionally format
at:
http://allenbrowne.com/ser-52.html