Charlotte Foust
cfoust at infostatsystems.com
Wed May 5 18:35:03 CDT 2004
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