Force new page using VBA 1

[cglisc]

Howdy,

I have to built a report that has a detail section that
must always print 20 lines. So if the record count is
5, print the 5 records, and then print 15 blank lines.
Using code from

http://support.microsoft.com/default.aspx?scid=kb;en-us;119073

I was able to do this.

However, if the number of records to print is more than 20,
then I should print the first 20 records, print the page
footer and then continue on the next page. How do I do
this?

Thank you for your help.
Chris.

 

[SgtJarrow]

Did something similar not too long ago.....

put a page break at the bottom of the report. Set the visible property to false. In the Format of the details start a running count. When cout = 20, make page break visible. Then using the report header OnFormat, set the page break visible back to no.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com