Setting Decimal Places in Access

When you work with decimals, you must use the Single or Double data type. After specifying the data type, you should specify the number of decimal places using the Decimal Places property. When you're setting this property in Design view, the property offers a list of value settings from 0 to 15 and Auto. The Auto setting is the default and relies on the Format property to determine how many decimal values to display.

If you're using VBA to set this property, you can specify the values 0 through 15. If you want to specify the Auto setting, use the value 255. 

Access Index

Main Index

Tips Index