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.
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