Edit The Report with blank Rows

[alwazeer]

Hi All

I took this report from the following Post

Adding blank rows to a report

The report was made by the genius

arnelgp​

What I need is to show the Footer of the report when it is one page
and show it on the last page when the report has more than one page
While keeping the blank lines to fit the page

 

[Jjaeger14]

Have you attempted placing in the footer what you want, and then using the page footer's on format event to hide/display the content appropriately?

Jack
Owner
Microsoft Access Programmer

 

[Gasman]

Report footer?

 

[Jjaeger14]

OK. I guess that was a poor assumption on my part. Instead of trying to hide display the page footer based on the number of pages, use the report footer instead. the report footer displays on the last page of the report (which meets your criterion)

Jack
Owner
Data Control, LLC

 

[arnelgp]

see this one.

 

[alwazeer]

Thanks for your interest
When the number of records is less than 17 the report mode is correct
But when the number of reports increases, example 17 or higher gives the following error message
What I want when the report becomes more than one page, the footer moves to the last page without the need all the blank lines
Suppose we have one set of 28 records, the report will be of two sheets, so the appendix will be on the second sheet and not in the third sheet that contains the rest of the blank lines.

 

[arnelgp]

did you try the NewReport.accdb?
this is what i get if i select Group 1:

and this for "all groups"

and

 

[alwazeer]

Yes, I tried it

What I want is:

I need the first page to be filled with the same area as the footer
then the footer moves to the second page if the report has two pages.

The First Picture If the report one page
The second Picture if the report Two page

i made them by Word