Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    subreport problem (2007)

    I have a "Master" report made up of about 15 reports used as subreports. I can not figure out how to keep each subreport from spilling onto the next page when it is too long to fit on to the rest of a page that it starts on. I would like it to start on the top of the next page when there is not enough room for all of the data to fit on that page. I have looked for the trick, but to no avail. I hope someone can tell me what I am not doing correctly. Thanks.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: subreport problem (2007)

    I haven't checked yet, but is there a Keep Together fieldfor the subreport.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: subreport problem (2007)

    Subreports don't have a Keep Together property, at least not in Access 2003 and before; I assume it's the same in Access 2007 but I don't have that.
    You can force a subreport to stay together by placing it in a dummy report section that has Keep Together set to Yes. See ACC2002: Keeping Subreport or Text Box Data Together on a Page.

Posting Permissions

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