VBA export snafu after office updates

[SueK]

The following VBA line worked fine for a year (when
exporting from access xp) until Office 2002 updates were
installed this week.

DoCmd.OutputTo acOutputReport, stDocName,
acFormatTXT, "C:\myfile.s01"

After updates, the output record stops around cc168-178,
which is the middle of an address field, instead of the
correct end of 253.

Our work around is changing the output format
from "acFormatTXT" to "acFormatRTF" and then using Wordpad
to 'Save As' a txt file (ugh!).

Are there any patches for this out there?

Thank you for taking the time to read this.

sue k
..

 

[Bob Buckland ?:-\)]

Hi Sue,

What update was applied that changed the behavior?

Were there updates to Windows or 3rd party software also applied?

You may also want to post this in the MS Access newsgroups
(links below).

========

The following VBA line worked fine for a year (when
exporting from access xp) until Office 2002 updates were
installed this week.

DoCmd.OutputTo acOutputReport, stDocName,
acFormatTXT, "C:\myfile.s01"

After updates, the output record stops around cc168-178,
which is the middle of an address field, instead of the
correct end of 253.

Our work around is changing the output format
from "acFormatTXT" to "acFormatRTF" and then using Wordpad
to 'Save As' a txt file (ugh!).

Are there any patches for this out there?

Thank you for taking the time to read this.

sue k>>
--
Let us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

MS Office Community selected newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx

Complete MS Office products newsgroup access via Outlook Express or other Newsreader
news://msnews.microsoft.com

Specific newsgroup mentioned in this message:
news://msnews.microsoft.com/microsoft.public.access
http://microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.access&lang=en&cr=US