Getting decimal places to display in a report in text boxes

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

I have multiple text boxes in a report; a few have a simple number as the
control. the others are calculated numbers. No matter what i do in the
properties of any of the boxes, i cannot get the decimals to display on the
report, ie 42.00 is displayed as 42, 56.70 is displayed as 56.7, 0 is not
displayed at all. I set the decimal property to two, and used the general
number format, but to no avail.
What is wrong?
thanks
Jerry Bennett
Mass
 
Some calculations might result in string values. You may need to wrap your
expressions in Val() to convert them to numeric. I would set the Format to
Standard and then set the number of decimal places.
 
Back
Top