473,396 Members | 1,734 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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
Nov 12 '05 #1
2 4637
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Anne | last post by:
Hi NG I have made a report in access, and i have used the OutPutTo to transfer it to word (rft format). It is a letter with addressheader, date, sign etc. The user should always add something in...
5
by: Mal | last post by:
Hi, I have a button on a form that outputs a report to word. While it has been working well for a while, today it is not. The behaviour now is that it endlessly outputs pages to word. There...
15
by: Mark C | last post by:
All, I have exhaustingly been looking through the newsgroups in search of a way to systemically output an Access 97 report to a pdf file using the full version of Adobe Acrobat. I want the user...
1
by: Midas NDT Sales | last post by:
Hopefully this is a simple question. I am trying to output a report from Access to Word, everything goes OK except the graphics. How can you get Access to output the graphics (a logo and a few...
3
by: Jorge Cecílio | last post by:
Hi! I would like to export some MS-Access reports output to pdf. However, the only possibility offered by Access (afaik) for me to export formatted output is snp (snapshot) (I use MS-Office...
2
by: Galina | last post by:
Hello All of a sudden I started getting error 13, type mismatch in a command, which was running happily for years. Here is a code: Option Compare Database Option Explicit Dim CmdClose1_Clicked...
0
by: jsloan23 | last post by:
I maintain a reporting database and all of the users can output a report to word just fine, but when one user outputs the report to word the report doesn't include all of the data. When she views the...
2
by: jambonjamasb | last post by:
Hi I have written code to output a report and add to lotus notes and send. The only problem is that when the report output rich text, so i lose all the details like checkboxes, field boxes, logo...
10
by: sara | last post by:
Hi - I have a report that is 14 columnar sub-reports (Line up: Position- holders in each of our 14 locations - Manager, Assistant Manager, Receiving, Office, etc). I output directly to PDF...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.