Jim Hewson
JHewson at karta.com
Thu May 6 13:43:05 CDT 2004
Without the control and using only a text box with plain text, it does not print more than 22 inches. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Thursday, May 06, 2004 11:17 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Report length limit...ugh You're on your on there. I wouldn't touch that design with a barge pole for any amount of money! You aren't really talking about the limitations of the report, you're talking about the limitations of the memo field control. Charlotte Foust -----Original Message----- From: Jim Hewson [mailto:JHewson at karta.com] Sent: Thursday, May 06, 2004 8:07 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Report length limit...ugh I was talking about the printed length. And yes, the client wants to print that amount. Here's the scenario: a monthly compilation of data with all the additions, counting, etc for 50 locations into one report. Comments are added to the report with one memo field. Usually text explaining what the data means... if there is any extenuating circumstances for an increase or decrease, etc. I am using FMS Total Access Memo to help with formatting, etc. On occasion, they have inserted a chart into the field to help explain the data. I have not been able to print more 22 inches of the memo field. In the "user's manual" there is one statement: "Excessively long memos may not print in their entirety on an Access report." Even without the FMS TA Memo it doesn't print past the 22 inches. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Thursday, May 06, 2004 10:34 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Report length limit...ugh 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 -- _______________________________________________ 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