Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 5th, 2005, 04:02 PM
Registered User
 
Join Date: Sep 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access 2000 Report Length

I'm tring to build a report that will produce a 4 page report. I've put all of my fields in the Detail section of the report and I've inserted 2 page breaks so far. My problem is that there is a 22" maxium Detail height and I can't fit anymore info in the report. Is there any way around this, or maybe a way to add an another Detail to the same report???
 
Old September 6th, 2005, 07:34 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Remove the page breaks.

mmcdonal
 
Old September 6th, 2005, 10:32 AM
Registered User
 
Join Date: Sep 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Doing that doesn't give me any more space in the detail.
 
Old September 6th, 2005, 10:52 AM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

So if I understand right...

This report has so many unique fields that it takes 4 pages to display them all?

Mike
EchoVue.com
 
Old September 6th, 2005, 10:57 AM
Registered User
 
Join Date: Sep 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Exactly.
 
Old September 6th, 2005, 12:29 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

How come there are so many fields in the report? What is the font size? :)
Perhaps this needs more sort fields so the detail section is not so large. This sounds like a huge mess of data.
Are you blowing out texts fields to the largest size you might need, instead of setting Can Grow to Yes? Things like that? Or is this all raw data in 8pt font?
Can you show a picture of the report in design view somewhere?

mmcdonal
 
Old September 6th, 2005, 12:59 PM
Registered User
 
Join Date: Sep 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I completely forgot about Can Grow. I had two large fields that I was able to shrink down. Thank you very much for the help.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Fixed length - SQL SERVER 2000 carumuga SQL Server 2000 4 December 23rd, 2006 10:18 AM
ACCESS 2000 Report problem on Windows 2003 scourge Access 1 April 19th, 2006 05:36 AM
Populate Access 2000 report text from form BradLee31 Access 1 September 16th, 2004 09:05 PM
SQL SERVER 2000 AND ACCESS 2000 ckentebe SQL Server 2000 3 June 17th, 2004 08:50 PM
ADE file in Access 2000 <---> Access XP ginoitalo Access 3 April 14th, 2004 09:06 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.