exporting text vs. screen resolution

  • Thread starter Thread starter Jan
  • Start date Start date
J

Jan

I am trying to export a report to a "formatted text (space
delimited) (*.prn) file. (This option is available in
Excel but not in Access, so I use OutputTo..acFormatTXT).

I have re-created the rows as single column text strings
so the spacing will be correct. However, with Access 2003,
when I export the file with an 800x600 screen resolution,
any text past 86 characters per line is dropped. With the
1024x728 resolution, the exported file is fine.

The receiving program has to have everything just so. It
will go away in six months when we change our core system,
but meanwhile. . .

This was not a problem in earlier versions of Access. My
users like to use the 800x600 resolution. Is there a cure
for this problem?

Thanks!
 
Hi Jan,

What happens if you change Page Setup to use wider paper, and increase
the width of the report detail section?
 
I check the output by opening the file in NotePad or MS-
DOS editor.

I changed the report to landscape with half-inch margins
and it still truncates the lines.

The problem occurs with Access 2003 on Windows 2000
Professional and Windows XP Professional. The problem does
not occur with Access XP.

The text that is there is properly spaced; it is just
truncated to 85 characters. Before I changed it all to one
text string each individual field was truncated.
 
Back
Top