IIF expression

[dunkster]

I have a report in which there is a Budget field and an Actual field.
If the Budget field is = zero and the Actual field is > zero I want to set the Actual field to zero else leave the Actual field with its existing data intact.
The IIF expression is as follows :
=IIF([Budget] = 0,0,[Actual])
The expression is entered in the ControlSource of the Actual control field.
This expression generates a "#error" message in the Actual control field.

 

[THWatson]

dunkster
Have a look at this article from the Microsoft site.

http://support.microsoft.com/default.aspx?scid=kb;en-us;209785

The text box would have to be unbound. If you created it from the [Actual] field, that probably is what is causing the #Error.

Tom

 

[Knicks]

Use an unbound field instead, not the original [actual] field