MS Access multiple page report

[Larry Muller]

I'm trying to create a four page report that is actually a contract in MS
Access.

My problem is the detail section of the report is limited by a Height limit
of 22". This keeps me from draging the footer section below the 22".When
I try to type something greater than 22" in the Height property, I get a
message that the number is too large.

Is there a way to increse the 22" maximum height limit that the Access Program
has? (This would be the easiest fix)

Or how do you create a multiple page report of more than three or four pages
in MS Access?

Any help is appreciated!!

Larry

[Paul Clement]

On 20 Dec 2000 15:32:51 -0800, "Larry Muller" <larry@horncreek.org> wrote:

¤
¤ I'm trying to create a four page report that is actually a contract in MS
¤ Access.
¤
¤ My problem is the detail section of the report is limited by a Height limit
¤ of 22". This keeps me from draging the footer section below the 22".When
¤ I try to type something greater than 22" in the Height property, I get a
¤ message that the number is too large.
¤
¤ Is there a way to increse the 22" maximum height limit that the Access Program
¤ has? (This would be the easiest fix)
¤
¤ Or how do you create a multiple page report of more than three or four pages
¤ in MS Access?
¤
¤ Any help is appreciated!!

When you are working with Access reports you are designing for a single page. The amount of data you
have (at runtime) in addition to how you have designed the first page of the report, will determine
how many pages the report displays.


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

[Tim Martin]

I would define an individual report for each page. Then you can build a macro
that executes the four reports in the correct order.
When the pages print out, it all looks like one document.

"Larry Muller" <larry@horncreek.org> wrote:
>
>I'm trying to create a four page report that is actually a contract in MS
>Access.
>
>My problem is the detail section of the report is limited by a Height limit
>of 22". This keeps me from draging the footer section below the 22".When
>I try to type something greater than 22" in the Height property, I get a
>message that the number is too large.
>
>Is there a way to increse the 22" maximum height limit that the Access Program
>has? (This would be the easiest fix)
>
>Or how do you create a multiple page report of more than three or four pages
>in MS Access?
>
>Any help is appreciated!!
>
>Larry