Solved

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

Posted on 2014-11-06
2
242 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 35

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

831 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