Can Shrink

A

Al Camp

Steven,
Can Shrink applies primarily to reports, and only to the "printing" of Forms... not the
screen display
While it is possible to control the height of a text control on a form, according to
the length of the data it contains, other fields below that will not "come up or down"
accordingly...as occurs in reports.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
There are 10 types of people in the world.
Those who understand binary, and those who don't.
 
F

fredg

Does Can Shrink work on a form. I have tried it without success.

Thanks,

Steven
Click to expand...

From VBA help files:

The CanShrink property does not apply to form or report page header
and page footer sections, although it does apply to controls in such
sections.

This property affects the display of form sections and controls only
when the form is printed or previewed, not when the form is displayed
in Form view, Datasheet view, or Design view.
 
Top