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

Ryan W wrwehler at gmail.com
Wed Aug 16 20:17:41 CDT 2023


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?


More information about the AccessD mailing list