Access 2007 Bug?- Page Header Height

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?
 
R

Randy S

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
 
A

alanwf

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!
 
Y

Yoko Godinez

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

resize page header 1
Can't change height of group header 5
Access Can't Open a report in MS Access 2007 0
Can't change Page Footer or Report Footer height (stuck at 22 inch 0
Changing the height of a page header 3
Report header height differs based on page number 4
Detail section's Height property does not alter when shrinks / gro 2
report header and footer 6

Top