If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > Access 2007 changes Page Header Height in report

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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!
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #4 (permalink)  
Old
L33t Helpa Munky
 
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
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #6 (permalink)  
Old
L33t Helpa Munky
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On