Sets display and storage requirements for the Decimal Data Type.
Applies To
-
Fields
-
Forms
-
Pages
-
Text boxes
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 |
Remarks
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.
For text boxes, use this property to limit the number of decimal places that appear based on the setting for the field. You cannot increase the number of decimal places beyond what is set for the field. If the setting for the field is greater than the setting for the text box, then the setting for the text box is used to determine how to round the number.
Note |
---|
For text boxes, you can change this property setting at run time with C/AL code. |
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
© 2010 Microsoft Corporation. All rights reserved.