Exporting a Fixed-Width Text File

[elaineva]

When I export a table that contains number or currency fields to a fixed-width text file, the numbers in these fields become left-aligned automatically.

Does anyone know how I can export these fields and make them right-aligned??

 

[mikevh]

Check the data types of the fields that are coming out
left-aligned. They are probably actually text rather than
numbers. If you can change the fields to numbers and do
the export, they should come out right-aligned.

 

[ArkM]

mikevh: no, Access uses left-adjusted fields to export numbers too (apropos, it's standard for fixed length text export)...

 

[mikevh]

ArkM, you're right. My apologies...