conditional numeric formatting of field output on report
David McCormack wrote:
I have tried this but I keep getting an error. This is what I have:
=IIf([Operation]=2,Format([May], "##0.0"),Format([May], "##0.0%"))
I have a field that if the object [Operation] is equals to 2, I need the
field to be in a standard number format with one decimal place. Otherwise I
need the field to be in a percentage format with one decimal place.
I don't see a problem with the expression. If your error is
that the text box displays #Error, then try changing the
name of the text box to something other than the nae of a
field in the report's record source (eg. txtMay).
--
Marsh
MVP [MS Access]
|