ADODB Object
 
Syntax
 
byte = fieldobject.Precision
 
Description
Sets or returns a byte value that is the maximum number of digits allowed in a numeric Field object.
 
The Precision property sets or returns a byte value that defines the maximum number of digits that a number (numeric value) can have in a Field object. This maximum number is also referred to as the degree of precision.
 
Normally, Precision is read-only for a Field object. However, after the Value has been set for the Field object and after a subsequent Update method call for a Fields collection, it can become read/write.
See Also
Example
 
For Each objField In rsData.Fields
   Debug.Print objField.NumericScale
   Debug.Print objField.Precision
Next