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