Unwanted spaces between records (lines) on report

G

Guest

I have a report fed by a query. Each line of the report is a separate record
in the query. The report has a group header for each line. The issue is for
each record in the query thus each line on the report there appears to be a
half inch blank space between them. Every time the report formats for a new
record it appears to add some blank lines between them. I have looked at the
properties for the Line header. Is there a way to force the lines to be
printed on the report directly below each other without an spaces?

Thanks
 
R

Rick B

Is there extra vertical space in your report sections when you view it in
design-view, or are the sections all squeezed tight against the controls?

Have you tried setting the "can shrink" property for your detail section?
 
G

Guest

No vertical space that I can see exists. Everything is squeezed tight. I
even put some code in the sections that if not data cancel and upon
formatting a section I first set the Top value of every field in the section
to 0 then test the field. If data I place it by adjusting its Top value, if
no data I leave its Top value at 0. After all this I adjust the Height value
of the section to its smallest setting to accomodate the fields that have
data.

The Can Shrink property is set to Yes for all sections including the detail
section. All the data is placed perfectly except when there is a record
break (new line on the report) then there appears about a half inch space
down.

AARGH!
 
C

Chuck

Could the resetting of top value to something >0 be causing the problem?
Is resetting affecting more than one section?
Try not resetting.

Are all section widths less than available printing width. Usually this will
give an extra blank page - but ...
Chuck --
 

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


Top