Keep the trailing 0's

[Tony2021]

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.

[#2]

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

[#3 · Accepted solution]

In the property sheet, set Format to Fixed. The trailing zeroes will always be displayed

[#4]

thank you very much. They both work though.