Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
May 04, 2022
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...
access
  • isladogs's avatar
    isladogs
    May 04, 2022
    In the property sheet, set Format to Fixed. The trailing zeroes will always be displayed
isladogs's avatar
isladogs
MVP
May 04, 2022
In the property sheet, set Format to Fixed. The trailing zeroes will always be displayed
Tony2021's avatar
Tony2021
Iron Contributor
May 04, 2022
thank you very much. They both work though.

Resources