[AccessD] "Can Grow" Property in Report Page Header - Access2007

Old trick.  You can also group on the same field multiple times to control
what displays when.

Charlotte

On Thu, Apr 5, 2012 at 9:58 PM, Rocky Smolin <rockysmolin at bchacc.com> wrote:

> Brilliant!
>
> R
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
> Sent: Thursday, April 05, 2012 7:36 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] "Can Grow" Property in Report Page Header -
> Access2007
>
> Brad, unless you're working in Access 2007 or 2010 when an AutoHeight
> property was added that applies to page headers, here's the simplest
> workaround (it's probably the simplest in 2007 or 2010 too!):  Create a
> group header on the report. You can group on any value that will repeat so
> you can add a phony field to the dataset with a single repeating value in
> it
> and group on that.  Put your variable size "page header" fields in that
> group and set it to repeat.  Put all your other grouping and sorting under
> that.   Now you've got a "page header" that will handle different sizes of
> can grow/shrink controls and will repeat on every page.
>
> Charlotte Foust
>
> On Thu, Apr 5, 2012 at 6:24 PM, Brad Marks <BradM at blackforestltd.com>
> wrote:
>
> > Rocky,
> >
> > I set up a test report with the same control in both the report header
> > and the page header.  The "Can Grow" was set to "Yes" for this
> > control.
> >
> > The "Can Grow" was also set to "Yes" in the Report Header.
> >
> > There appears to not be a "Can Grow" available in the Page Header.
> >
> > I put a lot of data in the control.
> >
> > The control will grow in the Report Header, but it is cut off in the
> > Page Header.
> >
> > Our users want a field at the top of every page on one of our reports.
> > The catch is that this field can vary from 0 to 200+ bytes of data, so
> > it sure would be nice to be able to use a "Can Grow"
> > feature if there was one at the Page Header level.
> >
> > Thanks for your help,
> >
> > Brad
> >
> >
> >
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com on behalf of Rocky Smolin
> > Sent: Thu 4/5/2012 8:13 PM
> > To: 'Access Developers discussion and problem solving'
> > Subject: Re: [AccessD] "Can Grow" Property in Report Page Header -
> > Access2007
> >
> > I think if the can grow of the control with the data is set to true,
> > it'll push the header section big enough to fit.  Not sure but can you
> > try and let us know?
> >
> > Rocky
> >
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
> > Sent: Thursday, April 05, 2012 5:38 PM
> > To: Access Developers discussion and problem solving
> > Subject: [AccessD] "Can Grow" Property in Report Page Header - Access
> > 2007
> >
> > All,
> >
> > I just discovered that the "Can Grow" property is not available in a
> > report's Page Header section like it is the Report Header section.
> >
> > Is there some way to get around this?  Is this different with Access
> 2010?
> >
> > We have a report that has a field with a widely varying amount of data
> > that our users want at the top of every page.
> >
> > Thanks,
> > Brad
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> >
> >
> > Website: http://www.databaseadvisors.com
>
>
> >
> >
> >
> > --
> > This message has been scanned for viruses and dangerous content by
> > MailScanner, and is believed to be clean.
> >
> >
> >
> > --
> > 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
>
>
>