Printing on 2nd Page

[Guest]

I've have minium experience using Access (2002) but i manage to create a mbd
file which works great for me. I created the database table, a query which
gathers the data and then a report design that puts everything in place. My
problem is that certain reports doesn't show all the data because it to big.
Is there a way to have the rest of the data continue on the page 2 with the
same design report layout. Thanks inadvance.

 

[Guest]

Report sections and controls have a CanGrow property which, if set to true
(Yes in the properties sheet) causes them to grow dynamically to fit the
data. So for each control bound to a field in the report's underlying
RecordSource which might need to grow set its CanGrow property to True (if in
doubt do so), and set the CanGrow property of the section of the report, e.g.
the detail section or a group header or footer, also to True. You should now
find that the report grows as necessary to fit all the data in.

You'll probably also want to set the section's KeepTogether property to
True. This avoids awkward page breaks in the middle of a section if it can't
all be fitted on the rest of the current page.

There is also a CanShrink property which has the opposite effect causing a
control to shrink to zero height if Null. If there are non-shrinking
controls alongside, however, including graphic elements such as lines or
boxes, than the control will not shrink. Conversely, if a control grows then
graphic elements alongside it don't grow with it.

Ken Sheridan
Stafford, England