Can Grow Option

  • Thread starter Thread starter Barbara Rain
  • Start date Start date
B

Barbara Rain

I have a report which I would like to have in a table type of format... not
exactly but almost. Anyway - there is a line of fields each with the can
grow feature on... is there a way to make all of these fields be a uniform
size based on the maximum height needed for any one field?

Thanks much.

Barbara
 
Barbara said:
I have a report which I would like to have in a table type of format... not
exactly but almost. Anyway - there is a line of fields each with the can
grow feature on... is there a way to make all of these fields be a uniform
size based on the maximum height needed for any one field?


I don't think you care if the controls grow to the same
height as the tallest one. What you really want is the
border lines to be the same height.

Anyway, you can only change the height of controls in the
Format event, but the CanGrow Height is not known until the
Print event, kind of a catch22.

What all that boils down to is that you have to draw the
vertical lines yourself. This is done in the detail
section's Print event with a line of code for each text box:

Me.Line (Me.textbox1.Left, 0) - Step(0, 20000)
Me.Line (Me.textbox2.Left, 0) - Step(0, 20000)
Me.Line (Me.textbox3.Left, 0) - Step(0, 20000)
. . .
Me.Line (Me.Width, 0) - Step(0, 20000)

The Horizontal lines can be placed at design time by using
Line controls at the top and bottom of the detail section.

If you'd prefer you can use Stephen Lebans' PrintLines
function at www.lebans.com which takes care of all the above
stuff pretty automatically.
 
Back
Top