Display Value Depending on State of a Yes/No Field

[Stephen Drzewiczewski]

I have a report. One of the fields on the report is a
checkbox for a field Paid.

If Paid is False then in a seperate Textbox I want to
display the value from the Total field.

I was trying to use this in the Control Source...
=IIf([paid]=False,[total],0)

In the Paid = True records 0 appears.
In the Paid = False records #Error appears.

I've tried several different options, but I think it's
something very simple that I'm missing.

Thanks,
Steve D.

 

[Duane Hookom]

You might want to make sure the name of the text box is not the name of a
field.

 

[Stephen Drzewiczewski]

That was it!!!

Thanks