David Mcafee
dmcafee at pacbell.net
Mon May 23 12:22:54 CDT 2005
If you could estimate the number of characters per line, then you could adjust you text box height accordingly in teh form load or form current (if continuous) event. Assuming, you can fit 50 chars per line, you could do something like: Select Case Len(me.txtMyText) Case < 51 '1 row hieght me.txtMyText.Height = 0.1667 * 1440 Case <101 '2 row height me.txtMyText.Height = 0.1667 * 2 * 1440 Case <201 '4 row height me.txtMyText.Height = 0.1667 * 4 * 1440 Case <301 '6 row height me.txtMyText.Height = 0.1667 * 6 * 1440 Case Else End Select You, of course, would use values rather than math problems as teh actual height, but I showed this way, because its much easier (for me) to understand hieght by rows. HTH David McAfee --- Rocky Smolin - Beach Access Software <bchacc at san.rr.com> wrote: > Dear List: > > We are adding a database of resources and > information to The Sleep Advisor. What I thought I > would do is make a continuous form with Can Grow > text boxes so that the subjects could be displayed > with a vertical scroll bar and the boxes would grow > and shrink like a report (the text box is bound to a > memo field in the Resources table which holds the > actual text). > > But now I find out you can't do that. Can Grow > doesn't work in a form. > > I want this info in a form because it contains lots > of hyperlinks which won't work in a report. But now > I'm stumped. > > Anyone got any ideas? > > MTIA, > > Rocky Smolin > Beach Access Software > http://www.e-z-mrp.com > 858-259-4334 > > > I could set the height of the text box dynamically > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >