How can I set decimal places in a calculated control on a rpt?

[Guest]

I cannot change the format in a report to a fixed format for a calculated
control on my report, and when I change the decimal place it does not change
on the report. The decimal place option is required but does not work for a
calculated control. The decimal place setting in the query that it is bound
to works in the query view and design, but not when the control is used for
the report.

I have tried to use the round function but using this function ignores the
iff statement that is used to show/not show specific records.

 

[Guest]

Try using the format property of the report textbox.
#.##

 

[Guest]

Thanks Karl... I actually fixed the report yesterday prior to getting a
response. I used the round statement prior to the iif statement like this:>
Round(expression,2), but did not put the round statement within the iif
statement that I wanted it to round. There were I think 3 embedded iif
statements and I did not put the round function in the right place. Now, I
know that I have to embedd it into the statement according to where I need
the round to work. I am pretty new to writing such complex expressions and I
was having a hard time, but now i think it is resolved.

Thanks for your response. Your suggestion may have worked but I did not try
it.

Kim