Results 1 to 3 of 3
  1. #1
    ZA_Nick is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    2

    Angry Multiple pages in print preview of a single page report

    Hi, Geniusses



    I am building a report that should take exactly one page to print and everything fits perfectly.

    However, as soon as I get the print preview of the report, it gives me 18 (yes, 18) pages of report.

    The whole report is built in the Detail section - no page or report header or footer.

    As far as I can tell there is nothing wrong with the page margins.

    Please help if you can - my deadline is looming

  2. #2
    R_Badger is offline Knows a few tricks
    Windows XP Access 2003
    Join Date
    Feb 2012
    Location
    Suffolk, UK
    Posts
    262
    Your problem is probably in the fact it is in the detail section.

    The reasoning is that access looks to dump the detail of the data here.

    Try indeed moving it to the header or footer section.

    If that doesnt work if you can post a screenshot of what you have and I'll take another look.

  3. #3
    ZA_Nick is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    2
    Thank you, R_Badger.

    Still looking into it - considering how little data is actually contained in the report (most of it is formatting) and the fact that the report only displays data for one selected record is still strange.

    I'm keeping looking into it - I suspect the problem may be in the data source, so I'm going to try barking up that tree.

    Regards.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. One page report is printing as 666 pages
    By JackieEVSC in forum Reports
    Replies: 3
    Last Post: 12-20-2011, 10:10 AM
  2. Cannot navigate pages in print preview
    By RMI in forum Reports
    Replies: 4
    Last Post: 11-09-2011, 11:16 PM
  3. Replies: 1
    Last Post: 04-21-2011, 01:58 PM
  4. Multiple Pages Print
    By gmitchell@exbrief.com in forum Forms
    Replies: 1
    Last Post: 01-23-2011, 06:06 PM
  5. Can't see sub report in print preview
    By LoggyDoggy in forum Access
    Replies: 1
    Last Post: 04-20-2010, 05:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums