Brad Marks
BradM at blackforestltd.com
Thu Apr 5 21:40:47 CDT 2012
Rocky, The field that can grow comes from a database that is part of a purchased system. The users often enter data into this field as multiple lines (maybe 10 lines with 20 bytes in each line for example). I don't think that we want to make the Page Header big enough to handle the biggest number of bytes or lines used, as this would be wasting a lot of space in the case when the field only has 10 bytes of data. The "Can Grow" feature would be perfect if it was available for the Page Header Section, but it appears that this is not the case in Access 2007. Thanks for your assistance. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com on behalf of Rocky Smolin Sent: Thu 4/5/2012 9:05 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] "Can Grow" Property in Report Page Header - Access2007 What's the width of the control with the <=200 bytes? How big could it be? Portrait or Landscape? Could you just make it big enough to hold the biggest number of bytes? R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Thursday, April 05, 2012 6:24 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] "Can Grow" Property in Report Page Header - Access2007 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 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.