Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Ephrata, Washington, USA
    Thanked 0 Times in 0 Posts

    mutliple page report (2003 )

    I've been tasked wih putting all of our Human Resources employee forms into Access as reports. So far I haven't had any issues or problems, except when it comes to one long form. It's 6 pages long. I inserted page breaks, but it won't let me add any more than 2 1/2 pages. The ruler shows the detail as being 22", but the report is 2 1/2 pages (letter-sized paper). What am I doing wrong?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: mutliple page report (2003 )

    You aren't doing anything wrong. The maximum width and height of a section on a form or report is 22" (see Access specifications).
    One workaround is to split the form over the report header, detail and report footer sections, or to create dummy group headers/footers.
    Another workaround is to split the form over several reports, and to place these as subreports on a main report (setting the Can Grow property of the subreports and of the section that contains them to True).
    Yet another method is to create the form in Word, and to use mailmerge to populate it with data from Access.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts