Close up gaps in a report

[Box666]

I have a report based on a query. The query interrogates 30 fields,
the report then shows these 30 fields listed one under each other in
the main body of the report.

On most occasions the fields have a value, however sometimes only a
few of the fields have a volume in them. At those times the report
looks a little silly in that it only has (say) 7 of the 30 fields
completed and they can be spread down the report with big gaps before
the next appears. I really want them to appear underneath each other
and then shrink the gap at the bottom of the main body (have set
report to shrink / expand) but it does not have any effect on the
layout of the actual fields.

Can anybody assist please.



Bob

 

[fredg]

I have a report based on a query. The query interrogates 30 fields,
the report then shows these 30 fields listed one under each other in
the main body of the report.

On most occasions the fields have a value, however sometimes only a
few of the fields have a volume in them. At those times the report
looks a little silly in that it only has (say) 7 of the 30 fields
completed and they can be spread down the report with big gaps before
the next appears. I really want them to appear underneath each other
and then shrink the gap at the bottom of the main body (have set
report to shrink / expand) but it does not have any effect on the
layout of the actual fields.

Can anybody assist please.

Bob

Set each control's CanShrink property to Yes.
You mist also set the section that the controls are in (i.e. Detail
Section) CanShrink to Yes.

As long as there are NO OTHER controls on that same line, the data
will move up and remove gaps.