How can I allow controls to grow/shrink on a displayed form?

[Guest]

How can I allow controls to grow/shrink on a displayed form? (It looks like Can Shrink and Can Grow will allow you to see longer data in some controls when printed, but not when displayed.
-HJD

 

[Van T. Dinh]

Yes. CanGrow and CanShrink only apply to printing.

See Steplen Lebans' Web site:

http://www.lebans.com/autosize_textbox.htm

--
HTH
Van T. Dinh
MVP (Access)

How can I allow controls to grow/shrink on a displayed form? (It looks

like Can Shrink and Can Grow will allow you to see longer data in some
controls when printed, but not when displayed.)

 

[Stephen Lebans]

I need to delete that older solution Van. That Web page directs you to
use the newer project here:
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.

 

[Van T. Dinh]

Thanks, Stephen.

 

[HJD]

To clarify- I would like individual textboxes to
shrink/grow on a continuous form. Is that possible?
-HJD

-----Original Message-----
How can I allow controls to grow/shrink on a displayed

form? (It looks like Can Shrink and Can Grow will allow
you to see longer data in some controls when printed, but
not when displayed.)

 

[Van T. Dinh]

I haven't tried but I don't think so. What you think as multiple TextBoxes
is simply many instances of the SAME TextBox. These instances must have the
same height & width!

(Stephen Lebans may prove me wrong here)

 

[HJD]

Is there a solution that will work with continuous
displayed forms?

 

[Stephen Lebans]

Nope, I fully support you 100%. Just is not possible!
:-(

--

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

 

[Guest]

Wow, that stinks. Would either of you be OK with looking
at my Access file and telling me if you have any other
ideas? (I have also tried enabling scroll bars on all of
the text boxes, but I think it is very confusing for the
reader.)
HJD