allow subform to grow

[Angi]

My subform consists of contacts for a given company. Is there a way to
make the subform "grow" and make room to list all the contacts without
scroll bars? This subform is sitting above my other subform for notes
on the company and, obviously, the notes subform will have to move up
and down depending on the number of contacts. Is this possible or am I
just wishful thinking??

TIA

 

[Van T. Dinh]

IIRC, it is possible but probably not worth the effort. To do this, you
will need to find out the number of rows in the Subform's RecordSource and
then change the Height of the SubformControl. Then you will have to change
the Top position of all Controls appearing below this Subform. You _may_
even need to calculate the required Height of the Detail section of the
MainForm in advance and adjust it (for increased height) before you can move
the Controls (including SubformControls) around.

Then you may have the problem that the MainForm will be taller than the
screen can display and then the users will have to use the scrollbar to move
the MainForm up and down (which most users hate).

It sounds to me teaching the users to use the scrollbar in the Subform is a
much better option ...

 

[Angi]

Van,
Thanks for the reply. I figured as much. What I've decided to do is
put a button on the page that will allow them to view all the contacts
at once. I'm still going to use the scrollbar, but that's not what
they're used to and you know people and change!

Thanks again!
Angi