Text won't fit in text box, auto flow to next page?

[PTRACER]

It seems like I've tried everything to get this working...

I'm using Access for invoicing. Some customers buy many products and not all of the products will fit in the Detail section of one page, so simply do not appear at all.

How can I get Access to create a duplicate of Page 1, and continue showing the records on Page 2 that didn't fit on the first page?

 

[Pat Hartman]

That is the normal behavior so I'm not sure what is wrong. Are you using a subreport to show the product detail? Make sure that the shrink and grow properties are set to yes for the subreport control and make sure that no controls overlap.

 

[PTRACER]

Yes, it's actually in a subreport, not a text box.

It'll display the first 15 products, but won't display any more. I've tried selecting "Can Grow" etc., but that doesn't seem to work.

I have a Report Header, Page Header, Group Header, then the subreport with the products listed, then in the page footer, I have the Total Cost of all the items.

I suppose what I want to do is display the first 15 records on page 1 and the remaining records (e.g. 16-30) on a duplicate page. The one thing to note though is that I want the Total Cost to appear at the bottom of the final page, not the bottom of every page.

 

[Pat Hartman]

Make sure that the detail section header is also set to can grow.