Brad Marks
BradM at blackforestltd.com
Thu Apr 5 21:51:40 CDT 2012
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.