Can grow, can shrink, line spacing and hiding lines in reports

[MikeP125]

Hi,
I am a pretty solid programmer in Access and VBA, but I am really stumped on
the best way to handle the following situation. I have a form that has 20
check boxes. Each check box turns on or off a one line paragraph title and a
multi-line paragraph in a report. If all 20 check boxes are checked off the
report prints like the following:

Paragraph heading 1 (1 line)
Paragraph 1 (multi-line)
(blank line separates paragraph 1 from paragraph heading 2)

Paragraph heading 2 (1 line)
Paragraph 2 (multi-line)
(blank line separates paragraph 2 from paragraph heading 3)

Paragraph heading 3 (1 line)
Paragraph 3 (multi-line)
(blank line separates paragraph 3 from paragraph heading 4)

....etc., all the way down to paragraph 20

Paragraph heading 20 (1 line)
Paragraph 20 (multi-line)
end of report

If all 20 check boxes are set to true, the report prints OK. But as I turn
off certain check boxes, I have the corresponding pargraph headings and
paragraph set not to print for the boxes I set to false. The problem is the
spacing. I have all the fields shrunken to a flat line stacked one right
below the next and I turn the can grow property to Yes. So all the correct
information prints, but the line spacing is not even. Can anyone suggest the
best way to configure/program this report so that it looks more like a
professional document with even spacing as opposed to some wacky, unevenly
spaced printout?
Thanks.

 

[tina]

in the report Design view, don't be afraid to make the textbox controls a
"readable" height. just butt them up against each other, vertically and
without overlapping, and make sure you set *both* the CanGrow and CanShrink
properties to Yes, in both the textbox controls AND the report's Detail
section.

hth

 

[MikeP125]

Great! Thanks...

in the report Design view, don't be afraid to make the textbox controls a
"readable" height. just butt them up against each other, vertically and
without overlapping, and make sure you set *both* the CanGrow and CanShrink
properties to Yes, in both the textbox controls AND the report's Detail
section.

hth

 

[tina]

you're welcome...

Great! Thanks...