MS Access multiple page report


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: MS Access multiple page report

Hybrid View

  1. #1
    Larry Muller Guest

    MS Access multiple page report


    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

  2. #2
    Paul Clement Guest

    Re: MS Access multiple page report

    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)

  3. #3
    Tim Martin Guest

    Re: MS Access multiple page report


    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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center