S
seanl
Guest
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.
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 appreciated!!
Sean Lannigan
IT Administrator
Hetek Solutions Inc.
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.
Code:
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), ColorThe 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 appreciated!!
Sean Lannigan
IT Administrator
Hetek Solutions Inc.
Last edited:
