Displaying Check Boxes in Report

[Amber]

I have check boxes in the detail section of my report....there are five check
boxes and are setup vertically. Sometimes there is more than one box
checked, such as box 1 and box 5....when this is the case and I run the
report there is a gap of white space between the 1 check box and 5 check box.
How can I keep the check box results together on my report and eliminate the
white space when more than one box is checked?

Thanks...

 

[Duane Hookom]

I would create a union query to normalize the checkbox fields. Only include
the true records/values in the union query. Use this union query as the
record source of a subreport. There won't be any false/no records so they
won't take up space. The subreport can be set up to grow as needed. Make sure
you set the proper Link Master/Child values.