Access PDF Report not displaying all records?

[djspod]

Hi,

I have created an Access query which then feeds a report, the report displays all records.
However when the report is then generated to email (PDF) the report does not display all the records?

I think it may be a force new page/section issue or page margin but after several attempts and different page layout solutions, I have now come to a dead end.

Any help would be helpful.

I have attached a screen shot of the issue, as you will notice record 5 is missing off the print preview with only 1 page listed?



Thanks

 

[GinaWhipp]

Looks like you are using Datasheet View which is a Form which will not grow. Switch that to a Report (Subreport) and set Can Grow = Yes.

 

[djspod]

Thanks for your help Gina.

That has definitely helped..

It just needs a few tweaks now to get the report to fit nicely in a formated state for the PDF export.

Thanks again

 

[GinaWhipp]

You're welcome!