[AccessD] Problems with Page Breaks – Access 2013

[Stuart McLachlan]

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
>