Exporting to text file.

[CD Tom]

This is driving me nuts!!! I have a table that one of the columns is set as Double, Fixed, 3 digits. I try and export this to a .txt file for a backup using the docmd.transfert ext command but when I look at the file I only have 2 digits. What am I doing wrong and how can I get this to export 3 digits.
Hopefully come one can give me an answer.
Thanks for all your help.

[ADezii]

1. Create a Query based on your Table.
2. Create a Calculated Field which Formats the [Double] Field to display 3 digits, something similar to:
   

   NewDouble: Format([Double],"#,#,#.000")

3. Do not Show the original [Double] Field in the Output.
4. Show the Formatted Field ([NewDouble]) in the Output.
5. Used the Query in the TransferTtext Method and not the Table.

[CD Tom]

That worked great thanks for the help.

[CD Tom]

Thanks for the help.

[ADezii]

You are quite welcome, CD Tom.