This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 0%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Hi Experts
I am designing an invoice in MS Access. I need to make the height of detail section fixed so that the height remains same. Mainly i want the report footer to be positioned a little below. Currently if there is one row the detail section collapses and consequently my report footer moves up. I will appreciate suggestions from you
Best Regards
Hi Albert
Thanks very much for quickly looking into this. I appreciate. I did what you suggested. Now my detail section is tall. But only one record shows up for that space. I have done something like this in Crystal Reports way back in 1997. What you have done is exactly what i am looking for. So near yet so far!
Regards
Manish 
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 46%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Ok, it been some time for me too! - Create a separate report (with JUST details). Drop that into the detail section - set the size of this sub-report to ONE line, and set the sub report to can grow. So this will allow you to set/fix the size of the detail section, but the sub-report CAN GROW to expand into the detail area. So the sub report is set = can grow, and the detail area is fixed in size. I did not think you have to do this, but that does seem to be the case. You probably have to set the link master/child fields of that sub report to a parent ID that you hope you have.
R
Albert
You can "fix" the detail size. Just set BOTH can grow and can shrink to no:
eg this;
So you thus can "freeze" or fix the detail size.
So, I created a invoice in ms-access based on above - here I only have 3 entries - but note the blank space below (I have room for about 30 rows).
Same goes for heading and footing - you can freeze their size.
Regards,
Albert D. Kallal (Access MVP 2003-2017)
Edmonton, Alberta Canada
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 34%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKI%3C/text%3E%3C/svg%3E)
please upload database file.
Thanks very much Albert. This requires a sub report to accomplish. The sub-report did not work in the detail section. It kept on repeating n times if the invoice details had n rows. I put the sub-report in the report header, and it worked. Although i am done with this i am not sure if that is correct. However, I am eternally thankful to you for your help. I appreciate.
please upload file
I corrected the problem of detail section repeating n times depending on rows in the invoice details. I was referring to a record set that was de-normalized. I fixed the problem by the following method:
My sincere thanks to Albert and others good people who help in the community.
Best Regards
Manish
Great stuff - yes that is the suggested road here.
While the repot writer in Access can be a challenge? it also perhaps one of the most "killer" features in Access. Reports have the ability to have VBA code. Toss in things like sub-reports, and there is not a another report writer in existence that can match what Access can do.
For example, in my screen shot? I used VBA code to draw those vertical dividing lines. So, all in all? You can do general reports, fixed sized reports, and EVEN still output a form to pre-printed forms in a printer - a remarkable system access has in regards to reports - and they can do darn near anything you ask of them!
To be fair, with the rise of css and markup? Well, then such a report writer should be able to match what Access can achieve, but I not found such a system as of yet!
Regards,
Albert D. Kallal (Access MVP 2003-2017)
Edmonton, Alberta Canada
MS Access Reports is powerful, and the next "killer" feature i would be using is the VBA code which i am going to toss in to do the lines! Thanks Albert you helped me close the case
Regards
Manish