Printing/Split Sections (Access 2K)

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote

What exactly is your problem, and what aren’t the controls doing that they should?

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote