TransferText

[Dimitris Nikolakakis]

I want to export the result of a query to a text file and I have used the
'DoCmd.TransferText'.

All fields are left justified in the ASCii file.

How can I right justified some of them? For example, I want the Quantity,
Value to be right justified.


Thanks

 

[John Nurick]

Hi Dimitris,

Use calculated fields like these in the query:

fNumberField: Format([NumberField], "0000000")

fNumberField: Right(" " & Format([NumberField],
"#,##0.00"), 10)

fTextField: Right(" " & [TextField], 10)