Results 1 to 5 of 5
  1. #1
    Nicola is offline Novice
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    5

    height of Detail section in reports

    Hi everyone,



    I tried to increase the size of the detail section in my report, but it apparently has a maximum size of just under 56cm's? Anyway I can make my report bigger than that? I am using Access 2007.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Do you really need a height of a single record to be greater than 4 pages in height? Have you tried moving laterally as well as vertically?

  3. #3
    Nicola is offline Novice
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    5
    My report calls several subforms (which are pivot charts). The combined height of these should be greater than 56cm's for the graphs to display big enough to read easily. Right now I am squashing them in.

    I have tried making the size of the subforms within the report smaller, and then just allow the subforms to grow according to the size of the pivot chart, but then they start displaying on top of each other. I am not really an Access guru so it's possible I just don't have the settings right.

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Try using more width on your report then instead of just going vertically, you'll have to do some extra formatting to get your headers to come out looking alright but if you really can't limit the height of your report it's an option.

  5. #5
    Nicola is offline Novice
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    5
    Thanks, don't know why I didn't think of using the width myself
    It was a bit complicated getting it to print nicely, but its working now...

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

Similar Threads

  1. Columns in Report Detail Section only
    By gg80 in forum Reports
    Replies: 10
    Last Post: 08-03-2014, 07:41 PM
  2. Replies: 6
    Last Post: 03-26-2013, 12:17 PM
  3. Limit detail section to a certain size
    By DarrenUD in forum Reports
    Replies: 6
    Last Post: 11-07-2012, 01:02 PM
  4. Detail Section Keeps Repeating values
    By progamer in forum Reports
    Replies: 6
    Last Post: 07-30-2012, 10:28 PM
  5. Count in detail section of a report
    By ccordner in forum Reports
    Replies: 9
    Last Post: 02-08-2012, 06:55 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