Results 1 to 5 of 5
  1. #1
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581

    Can't add more pages to a report


    I'm creating a report where I have several text boxes. The text boxes have code to bring up sums and counts from a query. I have gotten to about 3 pages in the report and it won't allow me to add any more information. I cannot make it any bigger and when trying to add more text boxes, I get this:
    Click image for larger version. 

Name:	error.JPG 
Views:	26 
Size:	26.2 KB 
ID:	43088
    Is there a limit to the size a report?

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    Are you setting the report left,top,height or width with code?
    Are you exceeding any of the maximums allowed on a report? ... see this link ... http://www.avantixlearning.ca/micros...urse-resource/
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    the limit is the sum of all section heights in design view cannot exceed 22.75 inches/57.8cm (32767 twips). So perhaps reduce font size, spacing and/or height of controls and use cangrow/shrink. However don't think you can have controls that can collectively grow to more than 22.75 inches - you'll have to try it and see.

    Other alternatives are to redesign your report in a way to make better use of grouping (and therefore sections). No reason why you can't group on a PK for example

    Edit just checked moke's link, I was wrong, each section can be up to 22.75" high, with a maximum combined height of 200"

  4. #4
    A S MANN is offline Advanced System Analyst
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    India
    Posts
    161
    may be you can breake reports like Report-A,Report-B etc to manage width of report, These B reports will generate when A ends .

  5. #5
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    I ended up making it Report/SubReport. It seems to handle it pretty well. Thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 03-23-2018, 07:59 AM
  2. Report needs more pages
    By CHEECO in forum Access
    Replies: 2
    Last Post: 02-03-2018, 05:15 PM
  3. Report printing extra pages of the same report.
    By khughes46 in forum Reports
    Replies: 5
    Last Post: 06-19-2014, 07:39 AM
  4. Report pages
    By combine21 in forum Reports
    Replies: 1
    Last Post: 03-05-2011, 04:39 PM
  5. Blank pages between report pages
    By jonsuns7 in forum Reports
    Replies: 2
    Last Post: 10-01-2009, 05:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums