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

Brad Marks BradM at blackforestltd.com
Fri Apr 6 05:27:30 CDT 2012


Charlotte,

Thanks for the help and explanations.

I plan to experiment with the "dummy group" approach.

Brad


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Charlotte Foust
Sent: Thu 4/5/2012 10:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] "Can Grow" Property in Report Page Header - Access2007
 
Right, so do it the way I suggested.  I know that works.  Drop the page
header entirely and use the dummy group as your page header.  If it's set
to repeat the section, it will appear on each page.

Charlotte

On Thu, Apr 5, 2012 at 7:51 PM, Brad Marks <BradM at blackforestltd.com> wrote:

> Charlotte,
>
> Thanks for your ideas/insights.
>
> I am working with Access 2007.
>
> I have the Page Header Section "Auto Height" property set to Yes.
>
> I have the Can Grow set to Yes for the control in question.
>
> When were is a lot of data in this control, the Page Header Section
> does not expand and the data in the control is only partially shown
> on the report.
>
> When I put the control in the "Report Header" section, the section
> does grow and all of the data is shown
>
> This would work nicely if the users wanted the "expanding" data field only
> on the first page of the report.  However, they want this field
> on the top of every page of the report.
>
> Brad
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com on behalf of Charlotte Foust
> Sent: Thu 4/5/2012 9:35 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
>
>
>
> --
> 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

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.




More information about the AccessD mailing list