Avatar

Level 2

Sorry to keep revisiting this thread but after much wasted time I figure asking for help is the best thing to do.

My table has one header, six sections each with a variable number of body rows and a footer for subtotals, and after the sections, a footer for grand totals.

It looks like this:

HEADER FOR THE TABLE

Section1 -body row 1

               body row 2

               body row 3

               SECTION 1 FOOTER

Section2 -body row1

               body row2

               body row3

               body row4

               SECTION 2 Footer

FOOTER FOR WHOLE TABLE

I would like to be able to have sections appear only if necessary, and the trigger would be a checkbox in a hidden subform.

I can get individual body rows within the section and the section footer to hide, but I can't get the section as a whole to hide in one fell swoop.

In fact the only presence property I see for the sections is Visible, Visible (Screen Only), and Visible (Print Only). The rest are grayed out.  The screenshot below shows the issue.

ScreenShot001.png

Is this possible? I mean to hide sections (or groups of rows), rather than just single rows. If so what should I be looking for or doing?

Another question I have is this. Depending on the data, the sections could have more rows than could fit on a single page. What is the best way to deal with this, so that the table header appears at the top of each page, and the table footer only on the last page?  It would be preferable to do this in a way

so that if a section was going to end up spanning two pages, the whole section would instead go onto the next page rather than be split.

Thanks.

Harry.

Message was edited by: HarryOhm I tried the "insert image" function for the screenshot but for whatever reason it does not work.