=[Pages] with incorrect value in a report with subreports

[Bresart]

Hi, in the page header of a report with 3 levels of child subreports there's a textbox with its Control source property set to =[Pages], with another set to =[Page], so the result is Page N of M. This report can print a preselected number of records.

When the number of records fills about 30 pages (plants of a determinated family, with others subreports), there’s no problem, but if it fills 15 (plants of another different family and different content in the subreports) the textbox with the number of pages shows one less than the total they are, and the final page header shows Page 15 of 14.

Any way of going around it?

 

[boblarson]

Have you tried putting the text box for =[Pages] in the Report's REPORT FOOTER and then another text box in the header which references it instead?

Bob Larson
Access MVP
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[Bresart]

Thanks boblarson, i solved the problem by changing the property Force New Page of the subreport.