Forum Discussion
Solved
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 missin...
- 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
if you don't want it in table level format, use form and add the format there.
Format: 0.000000
