ExportText number justification

All numbers will be left justified as the lading zero's will be suppressed.
Did you try to append spaces to the left to get a fixed width like:

select right("          " & [numberfield],10) as FixedNumberField, ...

Nic;o)

Hello amangia,

What format are you exporting to?


Pete

I am exporting to a text file.

Did you try to export into a fixed format ?

Nic;o)

I am exporting to a fixed format and am using an export spec.

Hmm, strange as it looks like the number field is seen as text....
Did you try my uggly workaround ?

Nic;o)

To be honest, I don't know WHERE to put the workaround.  I am exporting out of a table.  I have a form with a button.  The Event Procedure behind it is:
DoCmd.TransferText acExportFixed, "FoodBuy Export Specification", "foodbuy1", "c:\RBF01" & " " & Format(Now(), "mm - yy") & ".txt", False.

Where abouts would I put the ugly little booger?

I did that, but still to no avail.  So...I got to thinking and changed the field type to TEXT.  Bingo!  Works now.  

Thanks Nic

Glad it works, success with the application !

Nic;o)