Forum Discussion
Solved
Force Fixed Decimal - 6 places
Hello experts, I am trying to force my field to use 6 decimal places but it seems to drop the zeros at the end. I have the field property set to "FIXED" and 6 decimals but it doesnt force 6 (thi...
- as suggested don't use Fixed as your Format.
instead use 0.000000 as Format property on your Table (design view) or Form/Report, etc.
That's how numbers work.
The trailing 0's are meaningless and will not be displayed for numbers. It means that the values are accurate as far as the digits appear.
However, the real issue here is DISPLAY, as opposed to STORAGE, of values.
What you want is a DISPLAY that varies from the default. And that can be handled with a Format() expression which forces the display of meaningless 0's to pad out the length.