conditional numeric formatting of field output on report
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.
"Duane Hookom" wrote:
You should be able to set a control source like:
=IIf([Jim]1,Format([Jim],"0.00"),Format([Jim],"0"))
--
Duane Hookom
Microsoft Access MVP
"JASelep" wrote:
I have a report that uses one area to display either a percentage or a count
I'd like to format the report field output so that if the value is less than
1 to format the number as a 2 decimal point percent and if it is 1 or greater
format it as an integer
the conditional formatting features I see deal with the conditional display
format and not the conditional numeric formatting
I've struggled to see if I could conditionally format the data at the
ControlSource point of the field properties or at the format point but have
hit deadends on both avenues
Jim-
|