Counting can grow/can shrink controls

[Al]

Hi, folks!

Access 2K2

I have a report whose detail section is made up of a vertical stack of
20 can grow/can shrink text box controls. The detail is for any given
account.

What I'd like to be able to do is somehow count those controls that
are "active and grown" for each account - wherever they may be in the
"stack" - so that I can perform a report operation if the number
exceeds a predetermined count.

Any ideas and/or suggestions and/or... ????

TIA
Al

 

[Al]

To kind of offer a solution:

What I have ended up doing is essentially looping through the controls
in question during the OnPrint event. Those controls whose heights are
greater than zero are "full grown." I do my thing accordingly

 

[Marshall Barton]

That's a valid approach. However, the big problem you may
have with this whole issue is that the CanGrow/CanShrink
height is not available until the Print event. However the
Print event is too late to do anything more than change a
control's color or value.

 

[Al]

Thanks, Marsh - absolutely correct

As it works out, I'm changing the control line spacing - works just
fine.