Conditional format field with "NA"

[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

 

[Marshall Barton]

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?

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

 

[Guest]

Marshall,

That did the trick. Thanks.

- Steve

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