ADODB Object
 
Syntax
 
byte = fieldobject.NumericScale
 
Description
Sets or returns a byte value that is the number of digits allowed to theright of the decimal point for a numeric Field object.
 
The NumericScale property returns a byte value that defines how many digits are stored to the right side of the decimal point for a numeric value (number) of a Field object. The number of digits stored on the right side is also referred to as the scale of the number.
 
The NumericScale property has read/write permission when being used to create recordsets, but converts to read-only when you open an already created recordset.
See Also
Example
 
For Each objField In rsData.Fields
   Debug.Print objField.NumericScale
   Debug.Print objField.Precision
Next