NumericScale property (ADO)

Applies to: Access 2013, Office 2013

Indicates the scale of numeric values in a Parameter or Field object.

Settings and return values

Sets or returns a Byte value that indicates the number of decimal places to which numeric values will be resolved.

Remarks

Use the NumericScale property to determine how many digits to the right of the decimal point will be used to represent values for a numeric Parameter or Field object.

For Parameter objects, the NumericScale property is read/write.

For a Field object, NumericScale is normally read-only. However, for new Field objects that have been appended to the Fields collection of a Record, NumericScale is read/write only after the Value property for the Field has been specified and the data provider has successfully added the new Field by calling the Update method of the Fields collection.