View Single Post
  #3  
Old February 21st, 2007, 09:41 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default conditional numeric formatting of field output on report

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-