How to print a fixed range report?

[rickyfong]

I would like to printout a 10 rows report even though I may got records less than 10 rows? Please advise how I can print some blank rows to achieve 10 rows per report? Thanks!

 

[vbaInet]

The process is to print the last record for that group several times and changing the fore color to white so it shows as blank.

I have attached something similar I did for someone on here a while ago. See if you can make sense of it. Notice that the default fore color is white but in your case you would need to do it programatically. In the example it prints as blank lines that correspond to the OrderTotal for that Category.

 

[rickyfong]

Just want to know is that the sample report only print out one blank line? Cause I suppose it will print out some records and then with some blank lines!!

 

[vbaInet]

Please reread my first post regarding your first question. You can print the blank lines after some records but like I mentioned you need to code it to print the LAST record for as many times as you want blank records, and change the fore color to white.