How do I get rid of empty space on my report?

[Guest]

This is just a simple report.....use a query to list customer information.
Each customer has 3 or 4 lines. There's a title in the page hdr area.
There's 4 lines of customer info in the detail area with a straight line
under it so the customers will be separated. The line is in the detail area.
The page number is in the footer.

When you display the report the first customer prints fine, right up under
the title (or page header). But there is one whole line of space after the
line under the first customer, before the next customer prints.

I just can't figure out where this blank line (or space) is coming from.
All of the customer detail fields are all squished up to together. There is
no blank space between the detail border and the footer border. In fact if I
try to move them up, they flip up to the header area.

The report is almost 300 pages long so eliminating this blank space could be
very helpful. Any suggestions to get rid of this space would appreciated.
Thanks,

 

[Marshall Barton]

This is just a simple report.....use a query to list customer information.
Each customer has 3 or 4 lines. There's a title in the page hdr area.
There's 4 lines of customer info in the detail area with a straight line
under it so the customers will be separated. The line is in the detail area.
The page number is in the footer.

When you display the report the first customer prints fine, right up under
the title (or page header). But there is one whole line of space after the
line under the first customer, before the next customer prints.

I just can't figure out where this blank line (or space) is coming from.
All of the customer detail fields are all squished up to together. There is
no blank space between the detail border and the footer border. In fact if I
try to move them up, they flip up to the header area.

It sounds like you have some blank space after the line in
the detail section. Try dragging the the bottom of the
section up to the line.

If that doesn't help, you can set the back color of each
section to a different color so you can identify where the
space is coming from.

 

[Guest]

Good Idea! I did that and the extra space is in the detail section.
For 2 of the address lines, I used the CanShrink (yes). Is it possible this
has something to do with it??

It's almost like, the amount of space for each customer has to be the same.
Like the address lines themselves will adjust up when there's not a second
address line, but overall each specific customer is alotted the amount of
space specified by the detail area of the report.

Could this be or am I way off base??

 

[Marshall Barton]

I thought the extra space was after the horizontal line, but
if it's up in the address area, then I think it likely that
you forget to set the details section's CanShrink property
to Yes.

 

[Guest]

It's the weirdest thing....the space is at the top, before the first line of
each detail section. The first person prints great. The name is right up
under the page header. The address shrinks like it's supposed to. It's the
second and rest of the customers on the page that have the blank space. In
fact, the first person on each page prints right. Like this.....

bottom line of the hdr ============================
1st name line Name
Name2 (canshrink)
Address
Address2 (canshrink)
City, State, Zip
Line in detail ____________________________ (right up under the
words)
Next person >>>>>> space
2nd name Name
Name2
Address
City, State, Zip
_________________________________________

From the second person on, there's that space before the name (the name2 and
address2 shrink correctly).
Why would the first person print okay and not the rest??? I am stumped.

I thought the extra space was after the horizontal line, but
if it's up in the address area, then I think it likely that
you forget to set the details section's CanShrink property
to Yes.
--
Marsh
MVP [MS Access]

Good Idea! I did that and the extra space is in the detail section.
For 2 of the address lines, I used the CanShrink (yes). Is it possible this
has something to do with it??

It's almost like, the amount of space for each customer has to be the same.
Like the address lines themselves will adjust up when there's not a second
address line, but overall each specific customer is alotted the amount of
space specified by the detail area of the report.

 

[Marshall Barton]

The only reason for that effect is if the bottom of the
detail section is that amount of space below the line. Try
dragging the top edge of the section bar below the detail
section up into the detail section. It will then snap down
to the highest point in the detail section it can and still
display all the controls in the detail section.

If that point is not right up against the line, it implies
that there is a control below the line and you should drag a
selection in the left side ruler form just below the line
down into the next section bar to highlight the problem
control.

 

[Guest]

Thank you! Thank you! Thank you! I found it!! Can I send you cookies!!

The only reason for that effect is if the bottom of the
detail section is that amount of space below the line. Try
dragging the top edge of the section bar below the detail
section up into the detail section. It will then snap down
to the highest point in the detail section it can and still
display all the controls in the detail section.

If that point is not right up against the line, it implies
that there is a control below the line and you should drag a
selection in the left side ruler form just below the line
down into the next section bar to highlight the problem
control.
--
Marsh
MVP [MS Access]

It's the weirdest thing....the space is at the top, before the first line of
each detail section. The first person prints great. The name is right up
under the page header. The address shrinks like it's supposed to. It's the
second and rest of the customers on the page that have the blank space. In
fact, the first person on each page prints right. Like this.....

bottom line of the hdr ============================
1st name line Name
Name2 (canshrink)
Address
Address2 (canshrink)
City, State, Zip
Line in detail ____________________________ (right up under the
words)
Next person >>>>>> space
2nd name Name
Name2
Address
City, State, Zip
_________________________________________

From the second person on, there's that space before the name (the name2 and
address2 shrink correctly).
Why would the first person print okay and not the rest??? I am stumped.

 

[Marshall Barton]

While cookies are a very nice thought, I'm happy with just a
"Thank you, that solved it" or, if you are really excited, a
"My Hero" ;-))