Spaces Between Check Boxes

[Amber]

I have built a report which contains information from check boxes. I have
coded the report so that it only shows the check boxes with values. My
problem is that there is a list of 9 check box option to choose from, they
are on the report in a vertical list, and so when I run the report if check
box 1 and 9 are checked the report has a white space gap between the two
values. The white space is where the other check boxes are placed on the
report.

I know there must be a way to eliminate the white space. If someoone could
tell me how to do this, I would appreciate it.

Thanks in advance....

 

[Evi]

You are using code to make the unticked checkboxes invisible? If yes, then
check that the CanGrow and CanShrink property of the Section that contains
the checkboxes are set to Yes, also that the other controls in the section
are also set with the Can Grow/Shrink Property set to Yes.
If you have labels (which don't have that property) replace them with text
boxes and let your code make them invisible too.

Evi

 

[Duane Hookom]

This sounds like your table structure might be un-normalized. I would create
a union query of the primary key from the table and each of the yes/no fields
like:

SELECT PkField, YesNo1Field as YN, "YesNo1" as Lbl
FROM tblYourTable
WHERE YesNo1Field = -1
UNION ALL
SELECT PkField, YesNo2Field, "YesNo2"
FROM tblYourTable
WHERE YesNo2Field = -1
UNION ALL
SELECT PkField, YesNo3Field, "YesNo3"
FROM tblYourTable
WHERE YesNo3Field = -1
UNION ALL
....etc...
SELECT PkField, YesNo9Field, "YesNo9"
FROM tblYourTable
WHERE YesNo9Field = -1;

Then build a subreport based on the union query and place it in the detail
section of your main report. Use the PkField to link master/child.