right align for some exported fields in txt format

  • Thread starter Thread starter srijan
  • Start date Start date
S

srijan

hi
I would like to export the data where certain field like
amount field to be right align when exported.. since all
the export .txt fields are left align.

Thanks
 
Hi Srijan,

Create a query that uses calculated fields like this:
RFieldName: Right(" " & [FieldName], 5)

The idea is to pad the contents of the field with the same number of
spaces as you want the exported field to have characters, and then take
just that number of characters from the end of the result.

If you want leading zeros on numeric fields, use something like this:
NFieldName: Format([FieldName], "000000")

hi
I would like to export the data where certain field like
amount field to be right align when exported.. since all
the export .txt fields are left align.

Thanks
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top