MS ACCESS Report Design Detail Section

MS-LovesAccess 96 Reputation points
2021-02-10T08:49:04.73+00:00

66248-invoice.pngHi 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

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
0 comments
Accepted answer
  1. MS-LovesAccess 96 Reputation points
    2021-02-11T05:32:53.947+00:00

    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 66853-invoice-detail-section-1.png

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Albert Kallal 5,226 Reputation points
    2021-02-11T02:04:23.11+00:00

    You can "fix" the detail size. Just set BOTH can grow and can shrink to no:

    eg this;

    66667-iv21.png

    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).

    66668-iv22.png

    Same goes for heading and footing - you can freeze their size.

    Regards,
    Albert D. Kallal (Access MVP 2003-2017)
    Edmonton, Alberta Canada

    0 comments
  2. MS-LovesAccess 96 Reputation points
    2021-02-12T05:51:44.3+00:00

    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.

    0 comments
  3. MS-LovesAccess 96 Reputation points
    2021-02-12T09:09:55.55+00:00

    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:

    1. Created a sub-report based on Invoice Details table. This has all the invoices detail rows.
    2. Created a main report based on Invoice (master) without the details
    3. Added the sub-report in the detail section as suggested by Albert
    4. Linked the fields.
    5. Done

    My sincere thanks to Albert and others good people who help in the community.

    Best Regards

    Manish

  4. MS-LovesAccess 96 Reputation points
    2021-02-15T06:14:54.75+00:00

    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

    0 comments