Print two different formats based upon the value of a field

[Jimcb8]

Fields:
FoodStamps This is a YES/NO field (printed in the first or second columns)
FSAmount This is a numeric field(always printed in the third column)

I have a preprint form with three columns
The first column is for a YES answer and I want to print YES if FoodStamps is TRUE
The second column is for a NO answer and I want to print NO if the FoodStamps is False
The third column is either blank if the first column is YES or the actual value if the second column is a NO

Two cases:

If FoodStamps is TRUE then print

YES Blanks
I have a preprinted form and I want the YES in the first column and blanks in the third column on the form regardless of what is in the fieldFSAmount



If FoodStamps is False then print
NO value in FSAmount


the NO in the second column and the value of what is in the FSAmount field printed in the third column

I tried to figure it out with conditional formatting with no luck.
Your thoughts are greatly appreciated.

 

[Mihail]

Take a look to the IIF() function