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

    Access 2007 changes Page Header Height in report

    I didn't get any responses in MS Discussion group, so I was hoping someone here could help... at the very least I hope someone with connections can get this bug to the folks at MS. My problem:

    Reports in a mdb file are OK when opened in design view and Print Preview in
    Access 2003. When the same mdb file is used with Access 2007, the Page
    Header Height of reports changes to 22". The height should be 1/2 inch and
    it is in Access 2003. The 22" height cannot be reduced or changed in Access 2007.
    There is a large (21.5"!) empty space under my column headings in the Page
    Header section. Is this a bug? Can anything be done?

    I can send the mdb file if that would help. Thanks in advance!

  2. #2
    Join Date
    Oct 2004
    Location
    Melbourne, Australia
    Posts
    201
    Could it be that one database is measuring in inches and the other in millimetres ? The arithmetic doesn't really addup, but gross variations of this kind in my experience often come down to variations in default values.

  3. #3
    Join Date
    Sep 2008
    Posts
    3
    Thanks for the idea, but its in inches... plus the other sections of the report are correct or the same in 03 and 07.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yet another of the issues with "migration" to 2007. How many reports go nuts?
    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 2008
    Posts
    3
    Quote Originally Posted by StarTrekker
    Yet another of the issues with "migration" to 2007. How many reports go nuts?

    All 3 reports in the mdb file are affected. The 3 reports are very similar.

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Consider yourself very very lucky that it wasn't 50.

    I would just re-create the reports, copying whatever you can from the existing ones.
    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
  •