Continuous form length

[TeeSee]

Hello all. I'm probably not using the correct search criteria .... but
can't find, on this group, how to adjust the length of a continuous
form based on the number of records which meet the criteria of a combo
box in the header of the same form. Assuming this can be done could
someone please point me in the right direction?
Sincere Thanks!

 

[John W. Vinson]

Hello all. I'm probably not using the correct search criteria .... but
can't find, on this group, how to adjust the length of a continuous
form based on the number of records which meet the criteria of a combo
box in the header of the same form. Assuming this can be done could
someone please point me in the right direction?
Sincere Thanks!

It's not at all easy to do, and in any case you're limited to 22" for the
total length of the form. Can you not just allow enough to fill the screen and
use scrollbars?

You would need to open the form in design view, do a nontrivial calculation of
the height in twips (1/1440") which would depend on the size of your font and
your textboxes, reopen the form in data view, probably requery it... it's
going to be complex and inefficient code for what I see as a very minor
benefit.

 

[TeeSee]

It's not at all easy to do, and in any case you're limited to 22" for the
total length of the form. Can you not just allow enough to fill the screen and
use scrollbars?

You would need to open the form in design view, do a nontrivial calculation of
the height in twips (1/1440") which would depend on the size of your fontand
your textboxes, reopen the form in data view, probably requery it... it's
going to be complex and inefficient code for what I see as a very minor
benefit.

Point taken! Thanks John.