Export to RTF

[News]

Am having a problem usink AK2 exporting a report to an RTF file. The Access
report has most fields and sections set to CanShrink and CanGrow. The report
looks fine, but the ends of a number of fields get cropped. Can export to a
PDF file OK, but I can't edit a PDF file.

Any ideas, or can't it be done?

THANKS

Phil

[Allen Browne]

Phil, there has always been problems with fields being truncated at 255
chars when exported to RTF.

From memory, I don't think MS has fixed all these issues. The kb articles
that discuss them are listed here:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

Scroll down to the "Exports" heading.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"News" <sylvia..bo**@t iscali.co.ukwro te in message
news:47******** **@mk-nntp-2.news.uk.tisca li.com...

Am having a problem usink AK2 exporting a report to an RTF file. The
Access report has most fields and sections set to CanShrink and CanGrow.
The report looks fine, but the ends of a number of fields get cropped. Can
export to a PDF file OK, but I can't edit a PDF file.

Any ideas, or can't it be done?

THANKS

Phil

[Phil Stanton]

Thanks for coming back, Allen

Curiouser and curiouser - the fields being truncated are ordinary text
fields, in particular, phone nos and boat names.
What is really odd that is on my machine at home, running XP there is no
problem. The problem shows up on both my laptop running XP and also with the
computer at the Yacht Club running Windows 2000.

Any other thoughts

Thanks

Phil

"Allen Browne" <Al*********@Se eSig.Invalidwro te in message
news:47******** *************** @per-qv1-newsreader-01.iinet.net.au ...

Phil, there has always been problems with fields being truncated at 255
chars when exported to RTF.

From memory, I don't think MS has fixed all these issues. The kb articles
that discuss them are listed here:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

Scroll down to the "Exports" heading.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"News" <sylvia..bo**@t iscali.co.ukwro te in message
news:47******** **@mk-nntp-2.news.uk.tisca li.com...

>Am having a problem usink AK2 exporting a report to an RTF file. The
Access report has most fields and sections set to CanShrink and CanGrow.
The report looks fine, but the ends of a number of fields get cropped.
Can export to a PDF file OK, but I can't edit a PDF file.

Any ideas, or can't it be done?

THANKS

Phil

[Allen Browne]

Text fields? Concatenated to more than 255 char?
Or truncating shorter than that?

Post the SQL statement, indicating the field types and sizes involved in the
concatenation. Something else must be going on.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******** *****@corp.supe rnews.com...

Thanks for coming back, Allen

Curiouser and curiouser - the fields being truncated are ordinary text
fields, in particular, phone nos and boat names.
What is really odd that is on my machine at home, running XP there is no
problem. The problem shows up on both my laptop running XP and also with
the computer at the Yacht Club running Windows 2000.

Any other thoughts

Thanks

Phil

"Allen Browne" <Al*********@Se eSig.Invalidwro te in message
news:47******** *************** @per-qv1-newsreader-01.iinet.net.au ...

>Phil, there has always been problems with fields being truncated at 255
chars when exported to RTF.

From memory, I don't think MS has fixed all these issues. The kb articles
that discuss them are listed here:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

Scroll down to the "Exports" heading.

"News" <sylvia..bo**@t iscali.co.ukwro te in message
news:47******* ***@mk-nntp-2.news.uk.tisca li.com...

>>Am having a problem usink AK2 exporting a report to an RTF file. The
Access report has most fields and sections set to CanShrink and CanGrow.
The report looks fine, but the ends of a number of fields get cropped.
Can export to a PDF file OK, but I can't edit a PDF file.

[Rick Brandt]

The truncation that happens when exporting to RTF has nothing to do with the
data type and is a completely different matter from the truncation of memo
fields seen in other situations.

It happens because the export to RTF feature is flawed. It has had this problem
since at least Access 95 and it has never been fixed and likely never will be.
At its roots are differences is font kerning, spacing, etc, between Access and
Word that cause text snippets to take up more horizontal space in Word than they
do in Access. This combined with soft line-wrapping rules and various other
factors cause the problem.

The solution is to NOT use the RTF option for anything but very simple tabular
data that does need CanGrow and CanShrink capabilities. Even then you need to
make many of your controls in the report wider than would otherwise be required.

You can fiddle around with the design of your report using your current data and
perhaps convince yourself that you have corrected the problem. That will be an
illusion. Once your data changes the problem will resurface.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Phil Stanton]

Thanks Rick.

Any thoughts on why the export is fine on 1 computer and truncated on the
other 2 machines, all running Office 2000?

Phil

"Rick Brandt" <ri*********@ho tmail.comwrote in message
news:PT******** ****@newssvr25. news.prodigy.ne t...

The truncation that happens when exporting to RTF has nothing to do with
the data type and is a completely different matter from the truncation of
memo fields seen in other situations.

It happens because the export to RTF feature is flawed. It has had this
problem since at least Access 95 and it has never been fixed and likely
never will be. At its roots are differences is font kerning, spacing, etc,
between Access and Word that cause text snippets to take up more
horizontal space in Word than they do in Access. This combined with soft
line-wrapping rules and various other factors cause the problem.

The solution is to NOT use the RTF option for anything but very simple
tabular data that does need CanGrow and CanShrink capabilities. Even then
you need to make many of your controls in the report wider than would
otherwise be required.

You can fiddle around with the design of your report using your current
data and perhaps convince yourself that you have corrected the problem.
That will be an illusion. Once your data changes the problem will
resurface.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Rick Brandt]

Phil Stanton wrote:

Thanks Rick.

Any thoughts on why the export is fine on 1 computer and truncated on
the other 2 machines, all running Office 2000?

The problem is influenced by your default printer driver and perhaps other
settings in Word and/or Access.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Allen Browne]

That's fair enough, Phil.

Off the top of my head, I can't tell you which lib does the exporting.
Perhaps you could start by just checking whether it's the same Office
service pack.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******** *****@corp.supe rnews.com...

Thanks Allen & Rick

BoatName is a field defined in the Boat table - no messing about with it
al all

MSJET40 version is 4.0.8618.0 on both machines. However as the report is
perfectly OK in access, the problem would appear to be in whatever bit of
software converts the access report to an RTF file. Is there a DLL that
does this or is it done by MSJET40. I had a sort of feeling that there
would be a "program" invoked to covert to an RTF file, a different
"program" to convert to Excel etc.

Will also recheck settings. Again any suggestion on which ones

[Phil Stanton]

Been playing further. Cant find any differences in settings. If however I
change the font from Arial to Arial Narrow and then export the report, the
RTF file is OK. Trouble is that I am already using 6 point Arial which is
just about readable. 6 point Arial narrow is very difficult to read.

Phil
"Allen Browne" <Al*********@Se eSig.Invalidwro te in message
news:47******** *************** @per-qv1-newsreader-01.iinet.net.au ...

That's fair enough, Phil.

Off the top of my head, I can't tell you which lib does the exporting.
Perhaps you could start by just checking whether it's the same Office
service pack.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******** *****@corp.supe rnews.com...

>Thanks Allen & Rick

BoatName is a field defined in the Boat table - no messing about with it
al all

MSJET40 version is 4.0.8618.0 on both machines. However as the report is
perfectly OK in access, the problem would appear to be in whatever bit of
software converts the access report to an RTF file. Is there a DLL that
does this or is it done by MSJET40. I had a sort of feeling that there
would be a "program" invoked to covert to an RTF file, a different
"program" to convert to Excel etc.

Will also recheck settings. Again any suggestion on which ones

[Allen Browne]

It's an issue with font metrics???

What happens if you use Arial CYR?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******** *****@corp.supe rnews.com...

Been playing further. Cant find any differences in settings. If however I
change the font from Arial to Arial Narrow and then export the report, the
RTF file is OK. Trouble is that I am already using 6 point Arial which is
just about readable. 6 point Arial narrow is very difficult to read.

Phil
"Allen Browne" <Al*********@Se eSig.Invalidwro te in message
news:47******** *************** @per-qv1-newsreader-01.iinet.net.au ...

>That's fair enough, Phil.

Off the top of my head, I can't tell you which lib does the exporting.
Perhaps you could start by just checking whether it's the same Office
service pack.

"Phil Stanton" <ph**@stantonfa mily.co.ukwrote in message
news:13******* ******@corp.sup ernews.com...

>>Thanks Allen & Rick

BoatName is a field defined in the Boat table - no messing about with it
al all

MSJET40 version is 4.0.8618.0 on both machines. However as the report is
perfectly OK in access, the problem would appear to be in whatever bit
of software converts the access report to an RTF file. Is there a DLL
that does this or is it done by MSJET40. I had a sort of feeling that
there would be a "program" invoked to covert to an RTF file, a different
"program" to convert to Excel etc.

Will also recheck settings. Again any suggestion on which ones