This has to be the most complicated problem I have ever had with reports in Access and it is a problem that has plagued me
for years. I am hoping someone can help me out with this one.
I am trying to print an invoice. For each of the fields in the detail section I want to separate them with a line. I have
used the following code to create a verticle line running from the top of the detail section to the bottom which ends when it
gets to the last record in the detail section.
Dim Color As Long
Me.ScaleMode = 5
Me.DrawWidth = 0
Color = RGB(128, 128, 128)
Me.Line (0.125, 0)-(0.125, 22), Color
Me.Line (7.9583, 0)-(7.9583, 22), Color
The problem is that the invoice totals (subtotal, taxes, grand total etc.) are calculated in the page footer which
appears at the bottom of the report and there is a big blank space between where the detail section ends and the page footer
starts. Below is an example.
I have checked and when the report jumps to more than 1 page the detail continues on the second page as normal, and the
vertical lines end when the data ends. As you can see the detail section could end at any point on any page so I am thinking
the way to do it is to use a group footer (which falls between the detail section and page footer) and change the height of
it dynamically to calulate the distance from the bottom of the detail section to the top of the page footer and set that as
the height of the group footer.
I have tried everything under the sun to make that space fill in with something and to no avail. Any help would be greatly
Hetek Solutions Inc.