Access, Fixed Decimal Places Number Format
This article explains how to create a field that will display a fixed number of decimal places in Access using Custom Number Formats.
–
How to?
Open the table in design view. Select the field you want to format. Put as many zeros after the decimal place as you would like digits to be displayed:
.000
Before:
After:
Note: The custom formatting applies to fields of the Number Data Type.
Note: If you don’t want the trailing zeros to appear you could use the # sign instead of zeros:
.###
You can download the sample file used in this article from the link below:
See also:
- Access, Add Leading Zeros Custom Number Formats
- Access, Convert User Input to Uppercase
- Access, Convert User Input to Lowercase
- Access Field Properties Locked
- Access Check If Field is Null, Conditional Macro
- First Letter Uppercase Only Access Tables
- First Letter Uppercase Only Access Form
If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com
One thought on “Access, Fixed Decimal Places Number Format”