Formatting report to page size

[cmbirk]

Hi Everyone,
I am creating a report with a subreport embedded in it. I am actually creating a few of these reports for my division. I was wondering if there was some way to make sure that the entirety of a particular column fits on a page. That is, that a column, either on the main report or the subreport, is not split in the middle by the end of a page. If the entire column does not fit on the page, I would like the whole thing to be carried over to the next page. Does anyone know how to do this?

Thanks,
Chris

[OldBirdman]

I'm not exactly sure from your example, but the GrpKeepTogether property of the report and/or the KeepTogether property of each group within the report might work for you. See Access Help GrpKeepTogether Property for all the details.

[cmbirk]

@OldBirdman
I believe that function keeps groups together vertically. Lets say I have 5 columns. Columns 1-3 fit on one page horizontally fine. Half of column 4 is on the first page, and half of column 4 is on the second page. How can I force columns 1-3 on the first and 4-5 on the second if 4 is split? I hope this helps.

Thanks,
Chris

[OldBirdman]

True, my suggestions were for vertical grouping, not horizontal.
I use Access2003 and don't think I can even do this, if I understand the problem, which I'm not sure I do.
Therefore, I'm not going to try to go further. Someone else will pick this up. Good Luck!

OldBirdman