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

Bill Benson bensonforums at gmail.com
Tue Jul 26 06:35:57 CDT 2016


1st I don't think Brad asked, I did.

Next what I am asking Nd not breaking through here js, in what event does
one intercept page breaks to sometimes allow them or not, ie,
detail_format? _print?  Some page related event? I have never needed it but
if you never want it to get used you just wouldn't put it on the report at
all. So in what event would you make a decision to sometimes apply or
sometimes not.

I don't really care all that much, I was curious.

On Jul 26, 2016 6:46 AM, "Gustav Brock" <gustav at cactus.dk> wrote:

> 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
>
> --
> 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