Maximum Records per Page?

[adowen]

I have an access database with multiple reports. Each report contains a different amount of records that can print on the page.

I would like to print all the records for a group and then finish out the page with blank lines. I have entered modules based on the Microsoft knowledgebase article "How to Print a Constant Number of Lines per Group" from:

http://support.microsoft.com/support/kb/articles/Q119/0/73.asp

These modules will allow me to set the number of records I print to a constant value. Is there a simple way to calculate the number of records that will fit on a page and assign it to a MaxRecords value? That way I can reuse these modules and they will calculate the number of records that can fit on a page (not a constant value that I enter).

Thnx in advance

 

[bethabernathy]

Hi There: I have tried lots of different methods for what I think you are trying to do. You might want to look at this article on Microsofts Knowledge Base:

ACC2000: How to Control the Number of Records Printed per Page (Q209006)

Go to:

http://search.support.microsoft.com/kb/c.asp

Select Access 2000 (if that is what you are using) and input "Q209006" into the "My Question is" box.

I followed there example using the Northwind database and it made alot more sense than trying to customize it to my project. If this isn't what you are looking for, I have some other ideas, but thought this would be a good starting point.

Beth

 

[adowen]

Beth,

The information you have given me will probably work, I'll try it out later this week....

Do you know of a way to test whether it is time for a Pagebreak? If time for a pagebreak, I would think you could simply say go to the next record & print the next group.

Thnx again,