problem outputing a double to a text file

[SiE]

I am creating a text file using vba. I want the numbers that i am outputting to always show 2 decimal places but they are always 2 or less, for instance 5 will output as 5 rather than 5.00. My field type is double and I am using the round function to get my numbers to 2dp.

Anyone got any ideas?

 

[KenHigg]

In the underlying query, maybe something like:

myNewNumber: formatNumber(myNumberFld,2)

I think this is correct...

 

[WayneRyan]

Si,

How about:

Print #1, Format(Me.ThatField, "000,000,000.00")

or

Print #1, Format(rst!ThatField, "000,000,000.00")

hth,
Wayne