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

Stuart McLachlan stuart at lexacorp.com.pg
Tue Jul 26 01:41:00 CDT 2016


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





More information about the AccessD mailing list