Charlotte Foust
cfoust at infostatsystems.com
Thu May 6 10:34:02 CDT 2004
I was talking about the limitation on the physical length of the report or subreport object. I've never seen paper 22 inches long, but I certainly have printed reports with multiple printed pages, definitely exceeding 22 printed inches, which use subreports on a normal size report to handle the overflow. The physical length of all objects together doesn't exceed 22 inches, but the printed length does. The CanGrow properties allow the object to expand when needed. Are you talking about something else? Frankly, I've never wanted to print a 22 inch memo field, since to me that smacks of poor design. I don't see what good a memo field of that length would be since you couldn't put a useful index on it and I object to multicomment fields. Charlotte Foust -----Original Message----- From: Jim Hewson [mailto:JHewson at karta.com] Sent: Thursday, May 06, 2004 4:44 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Report length limit...ugh 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com