How do I Specify the precision in Decimal field in ADO

[gadgetguy1111]

Hello,

I'm creating a disconnected recordset to pass data for temporary storage.

while creating the fields, I used:

recForex.Fields.Append "Forex_A", adDecimal, 5

The problem I don't seem to be able to specify the precision of adDecimal.

As such, data passed to this field are without decimals

any idea how can i solve this problem?

thanks