none
Negative Percent field when entered by cursor is not displaying as it should be. RRS feed

  • Question

  • Everyone,

      I have a form where the fields control source is the database column.  This field is calculated on the screen and it displays as a -2.28, which is correct.  When I tab to the field, everything is fine.  Yet, when I put the cursor on the field, directly it changes to a value as -0.022755158951478.  I have it defined as percent with 2 decimal places.  How can I fix this to display as -0.0228 when I put the cursor on the field?  Thanx in advance and I look forward to hearing back.

    Jerry

    Wednesday, December 25, 2019 1:08 AM

Answers

  • Round the result of the calculation to 4 decimal places:

    Round(…, 4)

    (Since you haven't told us how you calculate the result, I can't provide more detailed information)


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by ballj_351 Wednesday, December 25, 2019 9:16 AM
    • Unmarked as answer by ballj_351 Wednesday, December 25, 2019 9:17 AM
    • Marked as answer by ballj_351 Wednesday, December 25, 2019 9:17 AM
    Wednesday, December 25, 2019 8:54 AM