Jim Hewson
JHewson at karta.com
Thu May 6 07:43:56 CDT 2004
Charlotte, I have to disagree on one point. Access will NOT print more than 22 inches in each section (subreports included). I have a report with one memo field in a section. The report will print up to 22 inches for that section, but no more, even if there is more data in the field. If you know how to ensure all the data in the memo field is printed, please enlighten me. Thanks, Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Wednesday, May 05, 2004 6:35 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Report length limit...ugh You can't do it that way. Use subreports instead. Each report, including each subreport can be no longer than 22 inches, but the length limit only applies to the individual components in design view. In addition to a limit on fields, Access reports have a limit on the total number of controls, including graphics and page breaks, that can ever be added to the report, no matter how many you might delete first. If you have a huge number of fields, then subreports is probably the only way to handle it regardless. Charlotte Foust -----Original Message----- From: Jamie Kriegel [mailto:jamie at kriegelpcsolutions.com] Sent: Tuesday, May 04, 2004 3:48 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Report length limit...ugh I'm building a report and my detail section needs to be longer than 22 inches? The report I'm building is an application with tons of fields that need to go in the detail section (it's about 4 pages if I print the blank word document). We are populating this database with values from our website and I'm trying to build a report to print out for HR. Any help would be great! Thanks, Jamie -- _______________________________________________ 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