Exporting to flat text file

M

M McGregor

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
 
J

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)
 
K

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.
 
Top