Access 2007 Bug?- Page Header Height

  • Thread starter Thread starter alanwf
  • Start date Start date
A

alanwf

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 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?
 
alanwf said:
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 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?
Click to expand...

Hi
Did you ever figure out an easy way to solve this problem? I am seeing
this also. Usually just a 1 or 2 reports per MDB. I solved it by creating a
backup of the reprot. Then turn off the headers and footers. Then turn them
back on. Then copy and paste the header and footer info from the back up. It
is a pain in the neck. It would sure be nice if you could change the Page
Header height property.

Thanks
 
Randy S said:
Hi
Did you ever figure out an easy way to solve this problem? I am seeing
this also. Usually just a 1 or 2 reports per MDB. I solved it by creating a
backup of the reprot. Then turn off the headers and footers. Then turn them
back on. Then copy and paste the header and footer info from the back up. It
is a pain in the neck. It would sure be nice if you could change the Page
Header height property.

Thanks
Click to expand...

Thanks for the reply. No, I haven't got a resolution for this. Your work
around seems to be the best bet for now. I just hope the folks at MS are
aware of this and "hopefully" working on fixing it!
 
I was having the same problem with one of my Access apps. I found out that it happened when there were 'grouped' objects in header area. I un-grouped them in 2003 and the problem was gone.
 
Back
Top