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
is there any way to change this?
Andy
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff Boyce
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?
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?
G
Guest
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 !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
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 !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
! ! ! !
J
Jeff Boyce
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.
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.
G
Guest
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.
tried all that n even making sections really long n having them shrinkable
but it still does not work. any other ideas.........
Andy.
T
Tom Lake
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?
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
J
Jeff Boyce
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...
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...
G
Guest
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
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
J
Jeff Boyce
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?
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?
L
Larry Linson
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
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
G
Guest
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.
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.
L
Larry Linson
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
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
G
Guest
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.
exactly where i have it but want access to fill the empty space with vertical
lines not blank space.
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.