Use VBA to force Page break in Report

[paxelius]

On my report, I've programmed lots of arrays to be displayed using VBA Print method.

My problem is that the my printout of the arrays just disappears under the 'physical' page in the report on screen. When I flip to the next page, the exact same array listing is displayed as on the previous page.

I've printed the arrays under Private Sub Report_Page(), maybe I need to make a different approach ?

I need to have this report up and working tomorrow, hope someone can help me in time.

Thanks you!

-Aeron Pax

 

[paxelius]

Lets not get caught up in the infamouse 'force page break' terminology here. Imagine I don't need a page break, but to control at some point in VBA that the rest of my array listings should print on a new page, how can we do this ?

-Aeron Pax

 

[dhookom]

Does the report have any record source? Have you tried setting a variable that contains where you left off printing your array? As a kludge, you could consider writing your array to a temporary table and then just binding the table into the report's record source or into a subreport's record source.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.