Fixed number of rows In Access Report

Question

Hello All,

I am having tried a access 2007 report with fixed numbers of rows (records) per page. For example, I like to fix total number of records (rows) to 10 per page while underlying query might have 5 records in some criteria or 15 records in some case. If any idea, please share me.

TIA ProNek

Answer 1

You can us a pagebreak with the visible property set to false and then make it visible when a counter reaches the relevant number.

Further information: http://support.microsoft.com/kb/119075

Answer 2

The link you mentioned help me but I am not sure whether it can print blank line.