Larry, thanks for coming back so quickly.
What I am trying to do is tell Word to create a text box the same size as
the one on the report and then fill it with text.
I can "read" the position of the text box from the report OK and create a
text box in Word with the correct position, but it's size is identical to
the size of the "ungrown" text box on the report. I need to create the text
box in Word the same size as the grown text box on the report.
Not had any luck in getting the grown height however. Have used
Debug.Print "Brochure Description Height " &
BrochDesc.Properties("Height")
Debug.Print "Host Phone Height " & HostPhone.Properties("Height")
Both give 570 twips
where BrochDesc and HostPhone are designed as the same height (1 cm = 570
twips), but the phone number is only about 10 figures, while the Brochure
Description can be a few hundred words, and jhas to grow to about 3" (8cm)
Thanks
Phil
"Larry Linson" <bo*****@localhost.not> wrote in message
news:xb******************@nwrddc01.gnilink.net...
In the Print event, you can access the height of a Text Box (in "twips",
1/1440th of an inch) after the "growth" has occurred. If you had planned,
however, to use it to set the height of some other Control, you'll get the
error message that you can't set the height in Print Preview or after
printing has started.
So, the question would be "for what purpose do you want the height of the
'grown' Text Box"?
"Phil Stanton" <ph**@stantonfamily.co.uk> wrote in message
news:3f*********************@mercury.nildram.net.. . Yes I know it can't be done in an editable form - well maybe not.
Assuming I have a report textbox with CanShrink and CanGrow set to yes,
is ther any way of calculating the length the textbox will grow to in order
to accomodate the text.
If so is this done OnFormat or OnPrint
Thanks
Phil