By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Output Report to Word

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.