Exporting to flat text file

[Guest]

I am trying to export a table to a flat text filw with fixed widths and would
like to get the last column to right justify. Any suggestions would be
greatly appreciated

 

[John Spencer]

Use a calculated field. Add the number of spaces (or other characters) to
the beginning of the string and then take the rightmost number of
characters.

Example
Assumption:
--Pad with spaces
--Length should be 25 characters

Field: PaddedField: Right(String(25, " ") & [TheField],25)

 

[kingston via AccessMonster.com]

Will this work for you? Create a report and export the report after you've
formatted it the way you want. Otherwise, you can create a query where the
fields are padded and export the query.