[AccessD] Problems with Page Breaks – Access 2013

[Brad Marks]

Stuart,


I tried to send the file, but was not able to do so.


Later, I followed your suggestion and used the "Force New Page - After Section" setting in the Footer.  This fixed the problem.


I also found some other posts on the Internet regarding a known problem with the "Page Break" marker embedded in Footers.  I will avoid using this approach in the future.


Thanks for your help, I really appreciate it.


Brad

________________________________
From: AccessD <accessd-bounces at databaseadvisors.com> on behalf of Stuart McLachlan <stuart at lexacorp.com.pg>
Sent: Thursday, August 25, 2016 5:02:01 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Problems with Page Breaks – Access 2013

Zip it and send it to me and I'll take a look.

I suspect that you may be better off using a sub-header with a ForecNewPage setting.

On 25 Aug 2016 at 21:48, Brad Marks wrote:

> All,
>
> I am working on a key report called the "Work Order Traveler" which
> contains the manufacturing specifications for items that we make.
>
> One Traveler is printed for each sales order.  Each Traveler is
> typically 2-5 pages long.  Many Travelers are created each day.
>
> There is a need to start a new page for each "Parent Item" on the
> Sales Order.
>
> I am running into a strange problem with Page Breaks.  When I insert
> the Access Page Break indicator in the report, an extra unwanted page
> is always created.  This is not good as we have page numbers at the
> bottom of the Traveler such as "Page 1 of 3".  We simply cannot throw
> away the extra page at the end as this would cause confusion for our
> workers.
>
> In order to debug this problem, I built a very simple Access
> application.
>
> This little application has one table with one field called
> "PageBreakNumber" with these values; 10,10,20.
>
> There is one query that obtains this single field and one report that
> simply displays this single field from the query.
>
> There is a "Group" on the PageBreakNumber field and an Access "Page
> Break" in the PageBreakNumber Footer.  These is no header.
>
> When I do a "Print Preview" of the report, I see the Page Break when
> the PageBreakNumber changes from 10 to 20.  So far, so good.  However,
> instead of generating just two pages as expected, a third page is
> generated.  This third page does not have any "detail" data.  It does
> have a Page Header and a Page footer, however.
>
> I have tried many things but I simply cannot find a way to prevent
> this extra page from being generated.
>
> I have not worked with Page Breaks very much.  Perhaps I am missing
> something.
>
> I could easily e-mail my Test application if anyone would like to look
> at it.
>
> Thanks,
> Brad
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com