blank lines in reports

G

Guest

I'm generating a report, but the height alloted for the information is
constant, even when the underlying data fields are null, and boths the field
and the detail sections have been set to "Can shrink". Is there a way to
allow neary empty sets of data to take less space in the report?
 
M

Marshall Barton

Twas said:
I'm generating a report, but the height alloted for the information is
constant, even when the underlying data fields are null, and boths the field
and the detail sections have been set to "Can shrink". Is there a way to
allow neary empty sets of data to take less space in the report?


CanShrink does do that. The issue you are probably seeing
is that the section can not shrink when there is another
control (label?) in the same horizontal area.

If that general statment is not sufficient to get you back
on track, please provide more details about the controls in
the section so I can try to be more specific.
 
G

Guest

The size of the report is constant, with most of the lines blank. The detail
section is very simple; a horizontal line at the top, then three rows of text
boxes for name, address, email (etc.) and comments. Everything except the
line at the top has "Can Shrink" set, but nothing shrinks. There are no
labels in the detail section at all. I even ran a query just to verify that
all the fields were null for the records I expected to shrink.
 
M

Marshall Barton

Twas said:
The size of the report is constant, with most of the lines blank. The detail
section is very simple; a horizontal line at the top, then three rows of text
boxes for name, address, email (etc.) and comments. Everything except the
line at the top has "Can Shrink" set, but nothing shrinks. There are no
labels in the detail section at all. I even ran a query just to verify that
all the fields were null for the records I expected to shrink.


Sorry to take so long to get bake to you, but I.ve been out
of touch for two weeks.

Double check that the section's CanShrink property is set to
Yes.

If that's not it, maybe you have a rectangle control around
all the text boxes??

If none of that helps, try setting the text boxes' and the
section's BackColor to different colors so you can see what
each is doing.
 

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

Top