How can I programmatically access 'Scale' property of a decimal data type field?

[FelicianoRa@coned.com]

Although I can find every other property of a field, I can find no programmatical way to get a decimal field's 'scale' property. I can find 'Precision' easy enough (despite the misnomer property name 'CollatingOrder'), and while "myField.Properties("DecimalPlaces")" gets the decimal places property value (with 255 = 'Auto'), the decimal places property is ignored for decimal values (it's only applied for 'Currency,' 'Fixed,' 'Standard,' 'Percent,' and 'Scientific,' but NOT Decimal! grrrr! ), and instead uses the 'Scale' property value. But despite cycling through each property of the field using "For Each myProperty in myField.Properties" there appears to be no property to extract a decimal field's 'Scale.' I need this capability in order to accurately document the database. Anyone know how (IF) this can be done, or did Microsoft just forget to include exposing it? [Note: This is an Access 2003 database]

[June7]

I have never used Decimal, which is a FieldSize parameter of Number datatype. I set Number types to Double if I want to allow decimal. What advantage do you expect for use of Decimal?

[Rawb]

June7, Decimal doesn't suffer from the same rounding errors that Double and Single do.

As for accessing the Scale, I'm not aware of any was to access that property. I'm no expert at ADO though, so there may be a way using that (there's not using DAO and ADOX though, I checked).

[FelicianoRa@coned.com]

Thanks for the replies. I've been tasked with documenting a host of old, huge (and poorly written) legacy Access systems, so the choice to use Decimal was not mine. From another site, it has been suggested that I try using ADO to get to the Scale property. I'll try that once they approve me for Admin rights on this machine so I can reference the Microsoft ActiveX Data Objects 2.x Library. Thanks again.

[FelicianoRa@coned.com]

OK, so to resolve the problem of access the Scale, I switched from DAO to ADO, which allows you to access Scale with code such as [myRS.Fields(FieldCnt).NumericScale]. However, this introduces its own limitations, as it appears that you cannot access the DESCRIPTION property of a field in ADO (but you can in DAO). Microsoft can be so infuriating!

[June7]

Guess you will have to use both ADO and DAO to get the output you want.