[AccessD] Need to Selectively Suppress Page Break on Access 2007 Report

[Jim Dettman]

 The OnFormat event of a section.

Jim. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Tuesday, July 26, 2016 05:44 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Need to Selectively Suppress Page Break on Access
2007 Report

Meant when does one toggle the visible property

On Jul 26, 2016 2:42 AM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote:

You can drop it on a report at any place that you want a page break. I
sometimes find it
useful to put one in front of a Subreport in a detail section so that it
starts on a new page.

Generally it allows you to control the pagination in a report where each
record needs to
covers multiple pages.



On 26 Jul 2016 at 2:07, Bill Benson wrote:

> I've read this has been around since A97, yet I have never had a need
> for it. When do you apply it? In a report event of some kind?
>
> On Jul 25, 2016 11:24 PM, "Brad Marks" <bradm at blackforestltd.com>
> wrote:
>
> > Gustav,
> >
> >
> > Thanks for the help.
> >
> >
> > Brad
> >
> >
> > ________________________________
> > From: AccessD <accessd-bounces at databaseadvisors.com> on behalf of
> > Gustav Brock <gustav at cactus.dk> Sent: Monday, July 25, 2016 7:22 AM
> > To: accessd at databaseadvisors.com Subject: Re: [AccessD] Need to
> > Selectively Suppress Page Break on Access 2007 Report
> >
> > Hi Brad
> >
> > Yes, set it's property Visible to false.
> >
> > /gustav
> > ________________________________________
> > Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af
> > Brad Marks <bradm at blackforestltd.com> Sendt: 25. juli 2016 13:39:36
> > Til: accessd at databaseadvisors.com Emne: [AccessD] Need to
> > Selectively Suppress Page Break on Access 2007 Report
> >
> > All,
> >
> > We have an Access 2007 Report that has a Page Break set up in a
> > report Footer on a field called Part-ID. This produces a report
> > which has a new page for each Part.
> >
> > Recently our uses have asked that we suppress this page break in
> > certain circumstances.  They would like to have some parts shown on
> > the same page, even though the Part-IDs differ.
> >
> > Is there a way to suppress a page break with a little VBA code?
> >
> > Thanks,
> >
> > Brad
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > AccessD Info Page - DataBase Advisors<
> > http://databaseadvisors.com/mailman/listinfo/accessd>
> > databaseadvisors.com
> > To see the collection of prior postings to the list, visit the
> > AccessD Archives. Using AccessD: To post a message to all the list
> > members, send email ...
> >
> >
> >
> > Website: http://www.databaseadvisors.com
> >
> > --
> > 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
> >
> --
> 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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com