By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,341 Members | 1,553 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,341 IT Pros & Developers. It's quick & easy.

Formatting report to page size

P: 18
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
Jul 20 '10 #1
Share this Question
Share on Google+
3 Replies


100+
P: 675
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.
Jul 20 '10 #2

P: 18
@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
Jul 20 '10 #3

100+
P: 675
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
Jul 20 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.