Remove multiple rows of Null fields in a report

I have created a report with multiple lines of data that could be null. I set
the fields to "can shrink." It does shrink the line and move it up a field
but if I have multiple fields in a row it does not bring the field all the
way to the top. Any ideas?

Brad wrote:

I have created a report with multiple lines of data that could be null. I set
the fields to "can shrink." It does shrink the line and move it up a field
but if I have multiple fields in a row it does not bring the field all the
way to the top.


A CanShrink text box will shrink, but the section containing
it can only reclain the otherwise **empty** horizontal bands
that were occupied by the text box (and/or other shrinking
text boxes).

Depending on all the other stuff in the section, you might
get closer to what you want if you can make the all the text
boxes shorter and set them to CanGrow. Regardless of what
you do, no text box below the CanGrow/CanShring text boxes
can end up with its Top above the bottom of the bottom of
any control above it.

Also, any control with its Top above the bottom of a
CanGrow/CanShrink text box will neither move up or down.

--
Marsh
MVP [MS Access]