Report details section being overwritten by subreport
Posted on 2004-09-24
I have an Access report report that has a details section that displays the results from a query that match up with the current date. Then I have a subreport beneath the details section that displays data that is related to the results from the record displayed in the details section. The problem is that one of the fields that is printed in the details section is a memo field so I had to set the CanGrow to yes to allow it to re-size as necessary to display the data. Whenever this happens the subreport ends up having it's data displayed with the second line of the details text displayed on top of it. How can I get around this? It seems as though I need to be able to move the subreport dynamically for each record.
The report was originally created in Access 2000 and now it is in Access 2003. Anything I do to the database must be backwards compatible with Access 2000.