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

[Gustav Brock]

Hi Brad 

When to use it? Well, didn't your users tell:

> to suppress this page break in certain circumstances.  

So you just have to clear up those "circumstances".

I can't remember when I last used the feature. Perhaps never.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Gustav Brock
Sendt: 25. juli 2016 14:22
Til: accessd at databaseadvisors.com
Emne: 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