dynamic textbox height

[Question Boy]

I have place an unbound extbox behind certain control, including a subreport
which can grow, which I then assign a color based on specific criteria. I
need the textbox to grow allow with the subreport for each record displayed.

I have tried

iheight = Me.Detail.Height
Me.Fab.Height = iheight

in the Detail_Format event but it seem to only perform the sub on the
initial record and I need it to adjust the size of the textbox for each
record. When I performed a debug.print on iheight it returned 960, 27 times
the number of records, rather than the distinct height for each record...
why? I am obviously not understanding the report events properly.

How can I adjust the height of the textbox for each detail independantly?

QB

 

[Duane Hookom]

If I understand correctly, you won't be able to determine a "grown" heght
until the On Print event. At that point, it is too late to change the height
of another control through code.

You can use code in the On Print event to draw a colored rectangle of almost
any height and position.