TransferText

  • Thread starter Thread starter Dimitris Nikolakakis
  • Start date Start date
D

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
 
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)
 
Back
Top