Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Location
    Columbus, Ohio, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing/Split Sections (Access 2K)

    Greetings all: Trying to print a horrendous report that has sections that split between pages. The CanGrow, CanShrink, KeepTogether properties don't seem to be working as advertised. What else could I be missing? TIA.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing/Split Sections (Access 2K)

    When you set the CanGrow property of a control to yes, you may have to set the CanGrow of the section also to yes. Same thing when you include a subreport.
    Hope this help
    Francois

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Printing/Split Sections (Access 2K)

    What exactly is your problem, and what aren't the controls doing that they should?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Printing/Split Sections (Access 2K)

    As Mark implied, you aren't very clear with what is wrong, however I can think of one possibility that has "burnt" me in the past. Which KeepTogether property are you referring to? Setting it in the properties of a section (where it can only be Yes or No) controls whether that particular section can split across pages. Setting it in Sorting and Grouping (where it can be No, Whole Group or First Detail) controls whether a section header or footer can be on a separate page from the detail section.

    If that doesn't answer your question, please elaborate.

  5. #5
    New Lounger
    Join Date
    Apr 2002
    Location
    Columbus, Ohio, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing/Split Sections (Access 2K)

    Let me re-phrase the problem. Is there a way to keep a header section and the corresponding detail section together if the data spans more than one page? Example: I have information about a street in a header, with detail information about the street in the detail section. The header sections breaks on [STREET1]

    HEADER SECTION INCLUDES:

    The parking regulations on the 203 foot long block face along the north side of [STREET1] from
    [STREET2] extending to [STREET3] shall be:

    Range, Code, Regulation

    DETAIL SECTION INCLUDES:

    000 - 115 feet, 2105.17, No Stopping Anytime
    115 - 203 feet, 2105.14, Bus Stop Only

    Would like to keep this all together if the detail goes to a different page. The detail section is variable, meaning the range could have many different regs applied.

    Hope this clarifies. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  6. #6
    New Lounger
    Join Date
    Apr 2002
    Location
    Columbus, Ohio, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing/Split Sections (Access 2K)

    Here I go again, finding solutions to my own problems. I put the report in design view and under 'Sorting and Grouping' tool, I changed the 'Keep Together' property here from 'No' to 'Whole Group'. Problem solved.

Posting Permissions

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