auto expanding text box

  • Thread starter Thread starter Antonio
  • Start date Start date
A

Antonio

Is there a way to set the properties of a text box on a
form to expand (grow) based on the amount of text that is
being displayed in the text box?
I know this is the case for a text box on a report, but
has anyone found a way around this for a text box on a
form? Either through the property settings or some code
behind the text box?
TIA
 
See:
http://www.lebans.com/textwidth-height.htm
TextHeightWidth.zip is a replacement for the Report object's TextWidth
and TextHeight methods. It is multiline aware and can work in both
Report and Form views. Includes a sample report to show you how to
autosize individual controls with different formatting on the same line
to simulate RTF style text.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Thank you very very much.

-----Original Message-----
See:
http://www.lebans.com/textwidth-height.htm
TextHeightWidth.zip is a replacement for the Report object's TextWidth
and TextHeight methods. It is multiline aware and can work in both
Report and Form views. Includes a sample report to show you how to
autosize individual controls with different formatting on the same line
to simulate RTF style text.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.




.
Click to expand...
 
Anthough, after looking at the example you provided....I
am not sure how learn and adapt what was presented to my
current needs....not really all that fluent with VBA
module, On current, On load examples you provided....
 
Antonio if you want this functionality then you will have to learn a
little bit about having code behind your Form and its controls. Before
you start this process though you must realize that my code will only
work for Forms in Single view. This means Continuous and Datasheet views
are not supported.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Well, I went out and purchased a book called "Teach
Yourself Visual Basic 6"....I take it that this is a good
place to start learning about code behind a form? Or did
I get the wrong book?
Antonio
 
Back
Top