Programming a report containing multi-page items

[Nick Bygrave]

I'm designing a report which is a series of three-page letters to various clients. Depending on a code in the clients' data, on Page 1, I need to show different text, and on Page 3 to include or not include a form.
Where do I include code in the Report VBA that makes those decisions?


Thanks for any advice.

[pbaldy]

Typically the Format event of the section being modified.

[Micron]

What data/text to put in a report should be governed by the report recordsource (query or table) and not report code. As for deciding whether or not to include a 3rd page, my suggestion would be to have 1 two page report with a subreport control if there is room near the bottom. If you assign a source object to the control in code that opens the report it should expand and create a 3rd page, else remain as a 2 page report. BTW, that control can initially be minimal in height to start in order to fit on the page. If you have no room at the bottom for a subreport control then I don't know.

[Nick Bygrave]

Thanks for advice. I will try it.