one more question

  • Thread starter Thread starter zane
  • Start date Start date
Z

zane

My report is essentially an excel spreadsheet. Thats the
look I am going for anyway. My problem now is how to get
the borders around each of my fields to grow and shrink
depending on the largest field in the row. any help
would be greatly appreciated.

Thanks
Zane
 
zane said:
My report is essentially an excel spreadsheet. Thats the
look I am going for anyway. My problem now is how to get
the borders around each of my fields to grow and shrink
depending on the largest field in the row. any help
would be greatly appreciated.
Click to expand...

Borders don't grow that way. It's even worse, because you
can only change the height of a control in the section's
Format event, but the final size of the controls is not
known until the Print event.

The way around all these issues is to draw the border lines
using the Line method in the Detail. section's Print event

Me.Line (Me.textbox1.Left, 0) - (Me.textboxN.Left +
Me.textboxN.Width, 0)
Me.Line (Me.textbox1.Left, Me.Section(0).Height) -
(Me.textboxN.Left + Me.textboxN.Width, Me.Section(0).Height)

Me.Line (Me.textbox1.Left, 0) - Step(0, 20*1440)
Me.Line (Me.textbox2.Left, 0) - Step(0, 20*1440)
. . .
Me.Line (Me.textboxN.Left, 0) - Step(0, 20*1440)
Me.Line (Me.textboxN.Left + Me.textboxN.Width, 0) -
Step(0, 20*1440)

If your situation is too complicated for that simple
approach, check out the PrintLines db at
www.lebans.com
 
Back
Top