Thanks Bonnie,

Interesting though. If you can define anything (decimal places) in the database environment, you should be able to retrieve it one way or another no?

If I remember correctly, "decimal places" is supported by standard SQL no?

It's probably me.

Thanks and kind regards,

Marc

PS : I totally agree that decimal places is not a storage but a formatting issue. Is it blasphematory then to want to define formatting at the DB level?

>Hi Marc,
>
>The DataColumn.DataType would indicate that it was a decimal datatype, but AFAIK, there is no specification for number of decimal places in a decimal datatype. That's pretty much a display thing, so there are various things you can do to specify how you want it formatted when you display it.
>
>http://msdn.microsoft.com/en-us/library/system.decimal.aspx
>
>~~Bonnie
>
>
>
>
>>In Access you can define a field "currency", give it a "Fxied" format and "Decimal Places".
>>
>>In DAO you would retrieve the "Decimal Places" as Properties("DecimalPlaces") of the ad hoc Field of the ad hoc TableDefinition.
>>
>>Anybody any idea where they would hide that in (vb).net (I would expect DataColumn, but I cannot find anything).
>>
>>Thanks and kind regards,
>>
>>Marc