Forum Discussion
Keep the trailing 0's
Hello experts,
I have a field in my table with following settings:
Double
Decimal Places = 6
It doesnt display 6 though.
It removes any trailing 0's
is there an extra setting I am missing?
I like the view to be "blocked" where all numbers have the same number of digits. Its easier to view and confirms that I didnt miss a digit.
- In the property sheet, set Format to Fixed. The trailing zeroes will always be displayed
- use the Format property (in design view of your table) of the Field (it pertains to the "appearance" of the value, it does not alter the "real" value saved on that field.)
if you don't want it in table level format, use form and add the format there.
Format: 0.000000
