Re: Continuous form length
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 31 Jul 2009 15:48:19 -0600
On Fri, 31 Jul 2009 13:44:02 -0700 (PDT), TeeSee <bkeanie@xxxxxxxxxxxxxxxxxxx>
wrote:
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.
--
John W. Vinson [MVP]
.
- Follow-Ups:
- Re: Continuous form length
- From: TeeSee
- Re: Continuous form length
- Prev by Date: RE: Combo box to limit selection based on current record in form
- Next by Date: Need help on this error --export to excel error message--
- Previous by thread: RE: Combo box to limit selection based on current record in form
- Next by thread: Re: Continuous form length
- Index(es):
Relevant Pages
|
