K
Kimberly Franklin
I recently upgraded my budget database from Access 2000 to Access 2003. Last
year we used an OutputTo command button to export a report and the available
formats would appear. MS-DOS was the format we used - being we imported the
result text file into our mainframe. Now that we have upgraded, MS-DOS is no
longer an option. When I select Text Files instead, it is truncating my
figures. I have changed the number formats to Fixed, O - and I double checked
the report layout and the fields are not overlapping and the fields all
appear to be wide enough to fit the figures when reviewing the report. Also,
the fields in the report are all on one row and are aligned. Is there a way
to possibly hard code an export using the MS-DOS format with v. 2003? The
code is using the OutputTo function - Is there a way to Transfer Text as
MS-DOS? It seems that MS-DOS format is the only format that does not truncate
my data. We have another workstation with Access 2000 and the exported file
is working. Any other suggestions? Thanks for any help or suggestions to get
me searching in the right direction.
year we used an OutputTo command button to export a report and the available
formats would appear. MS-DOS was the format we used - being we imported the
result text file into our mainframe. Now that we have upgraded, MS-DOS is no
longer an option. When I select Text Files instead, it is truncating my
figures. I have changed the number formats to Fixed, O - and I double checked
the report layout and the fields are not overlapping and the fields all
appear to be wide enough to fit the figures when reviewing the report. Also,
the fields in the report are all on one row and are aligned. Is there a way
to possibly hard code an export using the MS-DOS format with v. 2003? The
code is using the OutputTo function - Is there a way to Transfer Text as
MS-DOS? It seems that MS-DOS format is the only format that does not truncate
my data. We have another workstation with Access 2000 and the exported file
is working. Any other suggestions? Thanks for any help or suggestions to get
me searching in the right direction.