when a report has run out of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When a report runs out of data to display it fills the page with blank lines,
is there any way to change this?

Andy
 
Andy

This is not a facetious question...

If they are blank, how can you tell that they're there?

Are you saying you get a blank page following the last page of data? If so,
does your report have a property set to do (something like) a "page eject"
after each section of data?
 
No, there is the Report Header, then Page Header then the Detail section (in
this there are 3 lines of data say) then there is a big blank section before
the Page and report Footers. It is these blank lines i am talking about.

Im creating a table and want it to fill the page even when the data does not
so it does not look like this:

------------------------------------------------------
! A ! B ! C !
-----------------------------------------------------
! 12 ! 13 ! 14 !
! 17 ! 16 ! 15 !
! 18 ! 19 ! 20 !








! ! ! !
-----------------------------------------------------

But like this

------------------------------------------------------
! A ! B ! C !
-----------------------------------------------------
! 12 ! 13 ! 14 !
! 17 ! 16 ! 15 !
! 18 ! 19 ! 20 !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
 
Andy

The first place I'd look is in the properties of the Details section of the
report definition. Perhaps the CanGrow property is set to Yes, but the
CanShrink property is set to No.
 
Thanks for the response again jeff, but i wish it were that simple!! ive
tried all that n even making sections really long n having them shrinkable
but it still does not work. any other ideas.........

Andy.
 
Andy Bell said:
When a report runs out of data to display it fills the page with blank
lines,
is there any way to change this?
Click to expand...

How about drawing the vertical lines on the form itself rather than the
subform. Make them line up with the vertical lines on the subform and be
the entire height of the page.

Tom Lake
 
Andy

Does this happen on EVERY page, or just on some? If only on some, does it
happen early/late in the run of invoices?

Have you looked at the underlying query results to see if IT is generating
extra blank lines?

Have you set a break-point in the report code to see what steps its
following in formatting the detail section?

Just a few additional thoughts...
 
Jeff,

yes, it happens every time. I believe it is because the bottom of my table
is in the Page footer of the report.when there are no more records the detail
section ends and the blank space is placed there by access when it calculates
the size of the page etc when putting the footer on the bottom. i can have a
complete table by placing the base of the table in a section after 'Detail'
but more often than not my Invoices only have one item on them and the table
looks pointless if its only one line long. It may not be possible to alter
this fact, im a total Access novice! can you create some kind of template for
a report? are there any other ways i could try to create these invoices?

Andy
 
Andy

You may have already tried this...

If, as you say, you don't want the bottom of the report to be at the bottom
of the page, can you move the controls out of the PageFooter section and
into the Details section?
 
By definition, the Page Footer is at the bottom of the page -- you can't
change that, so on the final page, you need to put the corresponding
information in the Report Footer (and suppress printing the Page Footer on
that last Page). Check carefully the properties of the Report Footer -- by
default, it may be set to "New Page", but you can set the properties so it
prints immediately following the last data in the Report.

Larry Linson
Microsoft Access MVP
 
Dear all, thanks for all your help but Im sorry, i obviously have not made my
self clear. Let me try again.

I want to create a table that takes up the whole page and shows random
number of records (depending on which invoce is being created) in the table
without altering its size.

Currently when the records end the remainder of the page (before the footer
containing the base of the table, totals, VAT etc) is left blank. I want to
know if it is possible to alter this.

Regards

Andy.
 
What I don't understand is what you mean by "alter this". With what do you
want to fill the space between the detail and the page footer? That's the
only footer that would automatically be located at the very bottom of the
page.

Larry Linson
Microsoft Access MVP
 
i want to fill the space with lines to complete the table. i want everything
exactly where i have it but want access to fill the empty space with vertical
lines not blank space.
 
Back
Top