[AccessD] Forcing new page after last page in report?

[Ryan W]

Thanks Stuart!


I ended up making a custom group footer and using "page break before" and a
one line of code in the groupfooter0_format event so it only shows up if
it's the last page.



On Wed, Aug 16, 2023 at 10:02 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Can you build the key/appendix as a separate sub report and "Page Break
> Before"  that
> report.
>
> On 16 Aug 2023 at 20:17, Ryan W wrote:
>
> > I'm trying to create a key or an appendix for a report that won't fit
> > on the report itself.  I tried "force new page" settings (both
> > before/after/all conditions) a report footer section, which worked
> > until the textbox grew enough (about 3 inches tall in my testing) and
> > then it started doing weird things.
> >
> > I've got events for PageHeaderSection, PageFooterSection and Detail
> > section:
> >
> > cancel = (me.page = me.pages)
> >
> > so that it won't draw/produce page/header/footers/detail (detail may
> > not be necessary, but it's just part of the report code for now).
> >
> > Like I said this isn't working quite right if the textbox grows too
> > much.
> >
> > I've also tried a page break control but I'm getting similar results
> > to force new page  option but it's a mixed bag depending on the
> > report.. a single page report with a forced last page (so 2 pages
> > total) seems ok, but a 4-5 page report starts doing weird things on
> > the second to last page and the last page (the textbox ends up in the
> > detail section of page 4 and continues on page 5 even though that
> > textbox is NOT in the detail section of the report at all).
> >
> > Does anyone have some tricks/tips/wizardry/sage advice to offer on
> > this? -- AccessD mailing list AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd Website:
> > http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>