Solved

MS-Access -- Is there a max # of sub-reports that can be added to a blank report?

Posted on 2014-11-06
2
249 Views
Last Modified: 2014-11-06
Experts:

In MS-Access 2010, I’ve created 15 sub-reports.   I’m now adding the sub-reports to a “blank” report.    I can easily add 10 sub-reports to it (i.e., they "snap" right below each other).  However, once I get to the 11th sub-report, the container overlaps with the other sub-report containers.

Is there a maximum # (e.g., 10 ) of sub-reports that can be added to a blank (master) report?

Thanks,
EEH
0
Comment
Question by:ExpExchHelp
2 Comments
 
LVL 36

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40426213
I don't know of a specific maximum for subreports.  There is a maximum for controls and the subreport is a control but the max is far larger than 10.  Perhaps you are running into the max length of a report page which I think is 22".
0
 

Author Comment

by:ExpExchHelp
ID: 40426272
Ok... thanks for the info... I'll look into it.    

Alternatively, I may sub-group these 15 reports into different categories (each w/ < 10).

Thanks,
EEH
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

680 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