Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Detail Section Length

    I am trying to create about a six-page report, but finding that Access is not allowing me to make the detail section more than 22". I have tried pulling the bottom of the section down as well as typing in a new value in Page Setup/Columns. When I type in a number higher than 22" I get a message that says, "The number you entered is invalid."

    Is there a way to increase the detail section size?

    Thanks,
    Eric

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Detail Section Length

    That's correct. Certainly for Access'97 the maximum section height is 22". For more details lookup Microsoft Access Specifications in Help.

  3. #3
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Detail Section Length

    Thanks for the reply, Brian. I wish there was a way around this. Well, I guess we didn't really need more than 64k either. [img]/forums/images/smilies/smile.gif[/img]

    Eric

  4. #4
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Detail Section Length

    I checked out the specifications. It says that total height of all sections, including headers and footers, is 200 inches. If the Report, and Page headers and footers are each 22" and the detail section is 22", that makes a grand total of 110". Where do they get the other 90"? Is there a way to add an additional detail section or two?

    Thanks,
    Eric

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Detail Section Length

    The usual way to get around this is with subreports.
    Charlotte

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Detail Section Length

    You only have one detail section, but you can have several group headers and footers.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •