Avatar of kalees
kalees
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Access 2007 report detail section limit

All,

I am creating a quotation system within Access 2007 and wish to create a report to print the quote in PDF format. I need the report to be about 3 A4 pages long to enable a cover page, details page and a costings page. having started to create the report, I have come across the 22 inch limit.

Can anyone offer any ideas how to overcome this issue?

Many thanks in advance,

Keith

Microsoft Access

Avatar of undefined
Last Comment
kalees

8/22/2022 - Mon
Jim Dettman (EE MVE)

Keith,
<<Can anyone offer any ideas how to overcome this issue? >>
  22" is the limit.  Keep in mind that the detail section repeats for each record in your reports recordsource.  If you really need more room then that for a single record, then you'll need to use sub-reports for each of the sub sections that comprise the total information for that one item.  22" is a built-in limit and there is no way to change it.
JimD.
Dale Fye

Agree with Jim regarding the sub-reports.

When you drag them to your main report, you can make them .25", and set their CanGrow/CanShrink properties to True, then you stack those one above the other in the detail or in some group header or footer.  The challenge is get the sub-reports to print out on the pages you want them to, and to print only the desired info at in the page header/footer to make sure it is obvious which pages belong to which report.
kalees

ASKER
Thanks for the reply's

Are you suggesting with the sub reports to break down the report and create sub reports and then insert them into one report? The report that I am creating with all of the fields is only one record i.e the quote contains all of the information for one quote on one vehicle with one body and one set of contract details / payments.

Keith
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
kalees

ASKER
I have managed to achieve my goal through making use of the report header and footer which can also be extended to approx 22 inches. This has provided me with enough real estate to create the report. I will therefore declare this as solution provided by myself.

Keith
Dale Fye

Really?  Would you have figured that out without Jim's help?  I would have thought that Jim had at least earned an assist.
kalees

ASKER
fyed,

Not really wishing to get into a disagreement about this, however, based on your comment, I have again read through all of the comments made and still only see that the suggestion is to make use of sub reports, somthing that I have not done, maybe I did not make my resolution clear. I have used one report, streched out the report header to it's max, filled that with fields, using page breaks to split the section into pges. Next strech out the detail section a repeat as above, next strech out the report footer and repeat the steps again, filling with fields and using page breaks.

So againg, my point is, I have not used sub reports and do not think that they would have worked for me in this instance.

Should the group or admin disagree, I am more than happy to be guided.

Keith,

As a foot note, the resolution was stumbled across purly by trial and error.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Jim Dettman (EE MVE)

Well let me say I really don't have an issue with you accepting your own comment, but consider that your question was: "Can anyone offer any ideas how to overcome this issue? "
That is what you received.  However it was your choice not to use that suggestion (which would have worked fine) and find another.  Probably because you didn't want to go through the effort of restructuring the report (it's a lot of work to shift to sub reports).
But from what you posted in your question, there is no way anyone would know that you could achieve your purpose by making use of the report header and footer.
And of course I can't say for sure because I haven't seen the report or the detail involved, but I think you've probably backed yourself into a corner with using them in a way that your probably should not have, and at some point down the road, you are going to wish you had gone the sub report route.
JimD.
 
kalees

ASKER
JimD

I appreciate the reply and have read through it and agree that I did ask for ideas. Based on reviewing that, I am more than happy to award the points, please accept my appologies for the confusion (my own!) Sub reports is an idea that would possibly work for me but as you say, could have been time consuming.

Keith