Padding report height?

[mleefiend]

Hi,

I've got an invoice with columns. After printing out all the OrderID and details, I want the columns lines to continue to the bottom of the page. Is there anyway to fill the rest of the page, depending on the size of the detail section?

Thanks.

 

[jiqjaq]

You could do this a few ways. You can always draw line in the Print event using the Line method. Since you already have vertical lines that you want to extend, it's easier to just make them longer to match the section height.

In the Format event for the Detail, at the very end of the code, just before the End Sub, add:

Me.LineLeft.Height = Me.Section(acDetail).Height
Me.LineRight = Me.LineLeft.Height

LineLeft and LineRight are whatever your names are for the two lines.

 

[mleefiend]

Thanks for the reply jiqjaq, but there still seems to be one problem. The Me.Section(acDetail).Height seems to be a static height (presumably based on the report design height), but when the report is generated, that height actually varies. Is there anyway to find out the varying height?

 

[mleefiend]

Bringing it back to the top ... anyone?