Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2009
    Posts
    3

    Question Unanswered: Disappearing page Detail in Access 97 Report

    I'm a newbie w/Access 2007, but yrs ago worked with Access 97 so I know the bare minimum. I had built a report without the Wizard in A2007, and was able to print all the pages with the headers properly placed. Now I only get the detail on the first page, and only headers on the remaining pages. I deleted some queries which I did not think were being utilized in the report, but for all I kbnow that was what has caused the problem. Any ideas on rectifying this dilemma? Thanks

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Now I only get the detail on the first page, and only headers on the remaining pages.
    Now that is really strange behaviour. It sounds like labels for headings are placed in the detail section and the fields are in the report header!?

    You could always create a new report and copy the objects onto it... is there much code going on?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Sep 2009
    Posts
    3
    I'm sorry I wasn't clear on the dilemma. I get the header and detail on the first page, but only the header on the subsequent pages. I'll try the suggestions that were made and update my progress(?) Thanks for the help

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    So the first page is normal and on pages 2 - X only the page header shows; the detail section is gone?

    How many pages are there? Could it be that the width of the report is too wide?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Sep 2009
    Posts
    3
    That was it, the width. I finally discovered this when I took a blank report and just kept reducing the width and height until it printed. Then I took those dimensions and transferred them to the original. Works now. Thanks for the help

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Ah good, glad we got it sorted
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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