DecimalPlaces Property

Sets display and storage requirements for the Decimal Data Type.

Applies To

  • Page Fields

  • Report Columns

Property Value

You can enter minimum, maximum, or both values for the number of decimal places, as shown in the following examples.

Value Description
1 A minimum of 1 and a maximum of 1 decimal place.
1:4 A minimum of 1 and a maximum of 4 decimal places.
2: At least 2 decimal places.
:2 No more than 2 decimal places.


For decimal fields, this property specifies the number of decimal places that you want to store. The default storage requirements for Decimal Data Type are two decimal places for amounts. Use this property to specify storage requirements that are different than the default.

This setting is evaluated on text boxes and fields during validation.

When you create a new field of Decimal Data Type, the value is automatically formatted as a currency. If your decimal field does not contain a currency value, then you can use this property to determine the number of decimal places that appear on the screen. For example, in the G/L Entry table, the DecimalPlaces property of field 42, Quantity, is set to 0:5. The minimum number of decimal places that you can enter is 0 and the maximum is 5.

See Also

Decimal Data Type
Formatting the Data in a Field