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

Keeping elements of a report together.

P: n/a
Hi,

I've set up a sytem in our school for writing reports. It uses Access ...
and does a fine job! My problem comes with printing.

Each subject produces a report consisting of a series of coded data, levels,
targets etc, then text from a memo field. Different staff write different
amounts in the memo field. As a result I keep getting odd reports split
over a page.

I'm aware of the 'Keep together' property, but seems inapproprite in this
situation. A set of data for a subject is not a group. Putting in page
breaks leaves me too often with virtually empty pages. What I need is an
elastic band to put round all the fields for one subject!!

Any ideas

Thanks in advance
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"John M" <jo**@jmawer.demon.co.uk> wrote in message
news:c1*******************@news.demon.co.uk...
Hi,

I've set up a sytem in our school for writing reports. It uses Access ...
and does a fine job! My problem comes with printing.

Each subject produces a report consisting of a series of coded data, levels,
targets etc, then text from a memo field. Different staff write different
amounts in the memo field. As a result I keep getting odd reports split
over a page.

I'm aware of the 'Keep together' property, but seems inapproprite in this
situation. A set of data for a subject is not a group. Putting in page
breaks leaves me too often with virtually empty pages. What I need is an
elastic band to put round all the fields for one subject!!

Any ideas

Thanks in advance

Nov 12 '05 #2

P: n/a
John,

Put Subject in a subreport, make the Subject subreport control on your main
report only 1" in height and set the Can Shrink/Can Grow properties of the
Subject subreport control both to Yes.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"John M" <jo**@jmawer.demon.co.uk> wrote in message
news:c1*******************@news.demon.co.uk...
Hi,

I've set up a sytem in our school for writing reports. It uses Access ...
and does a fine job! My problem comes with printing.

Each subject produces a report consisting of a series of coded data, levels,
targets etc, then text from a memo field. Different staff write different
amounts in the memo field. As a result I keep getting odd reports split
over a page.

I'm aware of the 'Keep together' property, but seems inapproprite in this
situation. A set of data for a subject is not a group. Putting in page
breaks leaves me too often with virtually empty pages. What I need is an
elastic band to put round all the fields for one subject!!

Any ideas

Thanks in advance

Nov 12 '05 #3

P: n/a
If the printed data for a single record can exceed a single page then you're
stuck. However, if all records are less than a page in length then you do
want to keep together such that anytime a page would overflow the record
will begin on a new page. Other than that you get into tweaking your data
and the printed format in order to get a pleasing result.

HTH
--
-Larry-
--

"John M" <jo**@jmawer.demon.co.uk> wrote in message
news:c1*******************@news.demon.co.uk...
Hi,

I've set up a sytem in our school for writing reports. It uses Access ...
and does a fine job! My problem comes with printing.

Each subject produces a report consisting of a series of coded data, levels, targets etc, then text from a memo field. Different staff write different
amounts in the memo field. As a result I keep getting odd reports split
over a page.

I'm aware of the 'Keep together' property, but seems inapproprite in this
situation. A set of data for a subject is not a group. Putting in page
breaks leaves me too often with virtually empty pages. What I need is an
elastic band to put round all the fields for one subject!!

Any ideas

Thanks in advance

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.