Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 03:33 PM
Phil Stanton
Guest
 
Posts: n/a
Default Output Report to Word

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


  #2  
Old November 12th, 2005, 03:33 PM
Larry Linson
Guest
 
Posts: n/a
Default Re: Output Report to Word

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" <phil@stantonfamily.co.uk> wrote in message
news:3f95532e$0$111$65c69314@mercury.nildram.net.. .[color=blue]
> 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[/color]
to[color=blue]
> accomodate the text.
> If so is this done OnFormat or OnPrint
>
> Thanks
>
> Phil
>
>[/color]


  #3  
Old November 12th, 2005, 03:34 PM
Phil Stanton
Guest
 
Posts: n/a
Default Re: Output Report to Word

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" <bouncer@localhost.not> wrote in message
news:xbdlb.23451$Ee6.8822@nwrddc01.gnilink.net...[color=blue]
> 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" <phil@stantonfamily.co.uk> wrote in message
> news:3f95532e$0$111$65c69314@mercury.nildram.net.. .[color=green]
> > 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,[/color][/color]
is[color=blue][color=green]
> > ther any way of calculating the length the textbox will grow to in order[/color]
> to[color=green]
> > accomodate the text.
> > If so is this done OnFormat or OnPrint
> >
> > Thanks
> >
> > Phil
> >
> >[/color]
>
>[/color]


 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,174 network members.