Multiple detail sections in Access 2003

Posted on 2006-04-26
Last Modified: 2008-02-01
How do I get multiple detail sections on a form in Access 2003?  What I am trying to do is expand/contract the form based on user selections.  I was experimenting with this on a subreport, but all it does is provides additional whitespace.  

Anyone know how this can be accomplished in access?  
Question by:Delphinidae
    LVL 5

    Accepted Solution

    Well I know of no way you can add multiple Detail Sections since that's part of the core design of Forms, but you should be able to simulate it with subreports as you have guessed.

    I'm not sure what you tried with the subreports, so bear with me if I repeat what you've tried.
    I'd start by turning off the page header/footer and report heading/footing so that all you have is a detail section.  Then with that I'd minimize that section to one row with whatever you need to display.  Repeat this step for all of the 'detail' sections you need.

    When you embed them in the report shrink them so that nothing but a line shows.  Stack in sequence them as needed (not on top of each other) leaving just a little space between them.  If they are all set to grow when they have data then you can either let them pull their own data based on the report recordsource, or alternately push your own recorsource to each.  

    You might also be able to hide/show the particular subreports you need with an event on the OnFormat of the real detail section.

    Good luck
    LVL 58

    Assisted Solution


    This is unclear. As BPeb said, you basically cannot hack into the system, for both forms and reports you get exactly one detail section per record. You could duplicate records, but that's about it.

    I think we need to know what you exacly mean by "multiple detail sections". Let be give you a few examples:

    * Additional detail sections on reports

    You can simulate those by adding headers and footers for a dummy group on the ID of  the table, or any other unique field or field combination. This can be useful for some tricky formatting problems or code-based conditional layouts -- e.g. selecting one of several possible layouts for each record.

    * Additional *space* on reports

    During the Format event, it is still possible to change the metrics and the visible properties of the section and of all controls.

    * Additional "sections" on a form

    If you need to separate a form into different "sections", you can use page breaks. This is how all the control wizards, with [Prev] [Next] [Cancel] [Finish] buttons are created. Each "step" is a page, and you can surf among those pages (DoCmd.GotoPage).

    * Optional zone of a report

    Dialog boxes with an "Advanced>>" button to show more options in an expanded box use also a page break. The autosize of the form stops at that break, but you can manually increase the window size to reveal more controls...

    * Display multiple detail sections at once

    This is obtained by the "continuous form" view. Instead of showing one section at a time, several stacked detail sections are displayed, each showing a different record.

    As you see, "multiple detail sections" can mean different things...

    Care to explain a bit more?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now