Counting can grow/can shrink controls

  • Thread starter Thread starter Al
  • Start date Start date
A

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
 
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 :)
 
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.
 
Thanks, Marsh - absolutely correct :)

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