right justify number field in export

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I export an a2k table to a .txt file using Transfer Text in
a macro with a file spec. All is well except I need the
amount fields (defined in the spec files as Double) to be
right justified. They come out left justified. I want the
decimal point and trailing zeros. Lead zeros not
necessary but I'll take them if I must.

TIA
Jim
 
Jim said:
I export an a2k table to a .txt file using Transfer Text in
a macro with a file spec. All is well except I need the
amount fields (defined in the spec files as Double) to be
right justified. They come out left justified. I want the
decimal point and trailing zeros. Lead zeros not
necessary but I'll take them if I must.

TIA
Jim

Use a query for the export and use a format statement to format
the amount field.

examples:
Amount: format(rs!Amount, "###,###.00")
or
Amount: format(rs!Amount, "000,000.00")

Lookup "User defined numeric formats" in help.

Ron
 
Back
Top