Conditional format field with "NA"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with several calculated fields in unbound text boxes in the
Detail Section, based on a query. In the report, I would like for the text
boxes in the Detail Section to display "NA" when the value of the calculation
is "-1". Otherwise, the result should be the results of the calculation. Is
there a way to do this for all of the text boxes at once, rahter than coding
each of them?

Thanks.

- Steve
 
Steve said:
I have a report with several calculated fields in unbound text boxes in the
Detail Section, based on a query. In the report, I would like for the text
boxes in the Detail Section to display "NA" when the value of the calculation
is "-1". Otherwise, the result should be the results of the calculation. Is
there a way to do this for all of the text boxes at once, rahter than coding
each of them?
Click to expand...


If the result of the calculation is normally a non-negative
number, then you can select all the controls and set the
Format property to something like:

#,##0;"N/A";0
 
Marshall,

That did the trick. Thanks.

- Steve


Marshall Barton said:
If the result of the calculation is normally a non-negative
number, then you can select all the controls and set the
Format property to something like:

#,##0;"N/A";0
Click to expand...
 
Back
Top