line method draws line in different position in Access 2003 vs 200

[Lydia]

Hi,

I created this report in Access 2002-2003 format. In the on page event, it
draws a line at the bottom of each page. The position of the line is decided
by the sum of the controls height in the details sections. (This is necessary
that controls in details secitons may grow to accomodate long texts.) The
method works fine in 2002-2003 format. However when i open the database in
access 2007 with 2002-2003 format, the line cuts into bottom of records.

Please help. Thanks.

 

[Lydia]

I have found problem and solution to this question.

In a group footer of the report, there is a line. This group footer's height
is set to 0. In 2003, this doesn't pose problem however, in 2007, the height
of the group footer comes into play when you calculating the total height of
controls on each page. Add that height in when the footer prints, the problem
is solved.