Access 2003 to 2007 Conversion - Report section gets stuck at 22" in height
Posted on 2011-03-22
I just rolled out an updated copy of an Access 2003 front end to a client running Access 2003 and 2007. I tested the front end in the Access 2007 production environment and the Page Footer in a recently-modified report was stuck with a height of 22". To fix the issue, I cut the controls in the Page Footer, deleted it, added it, and re-added the controls. Here's my concern, when I update the database in the future, I'll have to go through the same exercise. Is there a manner in which I can configure the report on the development side (Access 2003) where I know it won't corrupt on the production side (Access 2007). I'm stuck with Access 2003 on the development side because there are still some Access 2003 clients on the production side.