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

M

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.
 
T

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
 
M

MikeP125

Great! Thanks...

tina said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"keep with next" not reliable in Word 2007 3
Modifying footer tabs creates unwanted line spacing changes 1
Final line spacing in paragraph is larger than the rest - why? Hel 3
Word: Change Default Font, Paragraph & Line Spacing 2
Document not layed out properly when not viewing hidden characters 6
Word 2003 - Apply Style - Not consistent 4
HEADING 1...HEADING 2 following styles not correct in a Quick StyleSet Options 1
Multiple styles in the same line? 1

Top