I am trying to make a landscape report so that each record, whether it has
only one line or many will print 2 records per page . Record space would be ,
4.25" high and 5.5" wide, half of page for each record. Record max lines will
all fit on half of page. I can't work out how to do this using columns.
Suggestions would be appreciated. Thank-you
Marshall Barton - 09 Jan 2006 02:54 GMT
>I am trying to make a landscape report so that each record, whether it has
>only one line or many will print 2 records per page . Record space would be ,
>4.25" high and 5.5" wide, half of page for each record. Record max lines will
>all fit on half of page. I can't work out how to do this using columns.
After laying out the controls in the detail section set the
section's CanGrow and CanShrink properties to No and the
Height property to a little less than 4 1/4 inches. Just so
you do not have to be too precise about thHeight setting,
set the section's KeepToGether property to Yes.

Signature
Marsh
MVP [MS Access]
eb1mom - 09 Jan 2006 10:09 GMT
Thank-you that works great