Keep together

[John M]

Hi
For reporting grades and comments about students, I use one subreport per
subject. This includes a number of text boxes, some containing numerical
data, but one containing a textual report. Depending on how much is
written, sometime there are three on a page, sometimes two etc. What I
cannot seem to do is to get it to 'not start a report for a subject unless
it can fit it on a page'. The keep together option seem to have no effect
in this case. I feel I want to put an elastice band round the various
fields, but there is no 'ealstic band option!!
Thanks in advance

[Allen Browne]

Put each of your subreports into a different section on the main report.

1. Open the main report in design view.

2. Open the Sorting and Grouping dialog.

3. Select the primary key field (probably StudentID).

4. In the lower pane, set Yes for both Group Header and Group Footer.
Access adds 2 new sections to the report.

5. Move the first subreport into the StudentID Group Header.
Move the last subreport into the StudentID Group Footer.
Leave the middle one in the Detail section.

Make sure the Keep Together is Yes for the 3 sections. Access won't start
the new section unless it will all fit on the page.

If necessary, you can add the StudentID again on the 2nd row of the
Sortin'n'Grouping box to get more group header/footers sections for your
subreports.
There is a design issue here that really bothers me though: you should not
run into this issue if you have a Student table, a Subject table, and a
junction table betweeen them. More info:
Relationships between Tables (School Grades example)
at:
http://members.iinet.net.au/~allenbrowne/casu-06.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

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

For reporting grades and comments about students, I use one subreport per
subject. This includes a number of text boxes, some containing numerical
data, but one containing a textual report. Depending on how much is
written, sometime there are three on a page, sometimes two etc. What I
cannot seem to do is to get it to 'not start a report for a subject unless
it can fit it on a page'. The keep together option seem to have no effect
in this case. I feel I want to put an elastice band round the various
fields, but there is no 'ealstic band option!!
Thanks in advance

[John M]

Excellent, thanks

In answer to your design issue point ... I think my way may be ok really!
All the basic data can be cut an pasted from out School information
management system (which does not have a decent reporting package). By
basic I mean personal details, classes, and teachers of those classes. I
create tables for each 'block' (this usually equate to subject). These
contain the reports, grades etc, and link to the basic data via student ID.
The fields are common to all of these so not only do I type no names, but
all the same forms reports code etc can be used. It all comes together
through a report. (Even this I ought to be able to get to reuse the same
one but fill it with different blocks. (I guess I've answered your point as
I'm not that confident that it is a good design!)

PS I gather it's poor form to ask of two Newsgroups, but I only just thought
of using the specific Reports Newsgroup after posting this.
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...

Put each of your subreports into a different section on the main report.

1. Open the main report in design view.

2. Open the Sorting and Grouping dialog.

3. Select the primary key field (probably StudentID).

4. In the lower pane, set Yes for both Group Header and Group Footer.
Access adds 2 new sections to the report.

5. Move the first subreport into the StudentID Group Header.
Move the last subreport into the StudentID Group Footer.
Leave the middle one in the Detail section.

Make sure the Keep Together is Yes for the 3 sections. Access won't start
the new section unless it will all fit on the page.

If necessary, you can add the StudentID again on the 2nd row of the
Sortin'n'Grouping box to get more group header/footers sections for your
subreports.
There is a design issue here that really bothers me though: you should not
run into this issue if you have a Student table, a Subject table, and a
junction table betweeen them. More info:
Relationships between Tables (School Grades example)
at:
http://members.iinet.net.au/~allenbrowne/casu-06.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

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

For reporting grades and comments about students, I use one subreport per subject. This includes a number of text boxes, some containing numerical data, but one containing a textual report. Depending on how much is
written, sometime there are three on a page, sometimes two etc. What I
cannot seem to do is to get it to 'not start a report for a subject unless it can fit it on a page'. The keep together option seem to have no effect in this case. I feel I want to put an elastice band round the various
fields, but there is no 'ealstic band option!!
Thanks in advance