Getting decimal places to display in a report in text boxes

[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

 

[Duane Hookom]

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.