RTF Export truncation

From: Terry Lowe (aijunk_at_hotmail.com)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 15:11:07 -0400

I could not find a resolution for this problem, but through trial and error
plus some newsgroup posts came up with a solution, so I thought I would post
it.

First, the problem. I had written an application in Access 97 on Windows 98.
Since the original app, the client upgraded OSes and Office versions to
where they are now on Windows XP and Office XP. The problems were noticed on
the latest platforms, but this may be a problem on other platforms as well.
The problem is essentially that fields in a report are arbitrarily cut off
when exporting to RTF. This export was working flawlessly under Access
97/Windows 98 and Access 2000/Windows 98.

The solution is essentially a combination of two bits of information found
elsewhere in the groups. The font and screen resolution (yeah, you read
correctly...screen resolution). The original font was MS Sans Serif and I
changed it to Microsoft Sans Serif, the screen resolution had to be above
800x600. It seemed that anything 1024x768 or above stopped cutting off the
text. I have no idea why screen resolution affected the exporting of a
report to RTF...I know Access somehow fits the print driver in there, but
screen resolution !??

I wish the problem only took that long to resolve. I tried multiple versions
of Access on fresh installs of Windows XP (Access 2K, 2K2, 2K3). I did not
try different patch levels becuase it happened on a vanilla install of
everything and was hapenning at the client site on completely patched
installs of WinXP and OfficeXP. It appears that Mircosoft changed/removed
the original font and maybe the substitute font was somehow dependent on the
screen resolution ?

I also tried expanding the fields, other fonts, different font sizes, and
most of the other obvious ways to resolve the problem.

Hope this saves someone some time.

Terry Lowe

Relevant Pages

  • Re: Size of Access Form
    ... Windows font size to "Other" - 105% which makes menus, message boxes, ... We have the resolution at 1024x768. ... to a larger display such that the increase in the physical size of the display ... The font-size setting for Windows should have made the text in your Access forms ...
    (microsoft.public.access.forms)
  • Re: [PHP] Re: posting variables to parent frame
    ... that there's no real standard for resolution. ... Atm, i repeat small images around the borders, but that's a real pain ... That will allow your users to change the font size on their browser to their preference without screwing up your design. ...
    (php.general)
  • Font size when changing screen resolution
    ... changing the screen resolution in Display Properties. ... In order to draw the text I have converted the font point size specified by ... seems to draw at the correct size in my native resolution of 1280x1024. ...
    (microsoft.public.win32.programmer.gdi)
  • RE: Font Size
    ... "Denise" wrote: ... The font size in Display Properties is ... On Appearance Tab make sure this option is set correctly: ... "Click on Settings and change the resolution to lower resolutions than the ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Imac G5 repair extension...
    ... The screen resolution is basically the same on the ... >> looks significantly more legible to the blind; I just don't like the form ... Most sites can change font size with your Font +/-, ... If you can't comfortably read an LCD at the native resolution, ...
    (uk.comp.sys.mac)
Quantcast