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

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