Connecting Tech Pros Worldwide Help | Site Map

Output Report to Word

  #1  
Old November 12th, 2005, 03:33 PM
Phil Stanton
Guest
 
Posts: 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


  #2  
Old November 12th, 2005, 03:33 PM
Larry Linson
Guest
 
Posts: n/a

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

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]


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
msaccess report output to word inconsistency jsloan23 answers 0 January 11th, 2008 05:28 PM
Failed to publish report to Word doc Scott answers 2 November 14th, 2006 01:25 PM
Report to word doc John answers 3 May 25th, 2006 02:05 PM
Publishing a Report to Word Scott answers 1 November 12th, 2005 03:25 PM