IIf in reports or elsewhere (1 Viewer)

[Erin Cimbri]

I have a bound control in a report called Amt. I put =IIf(IsNull([Amt]),0,[Amt]) in the control source property and get an error. I have the control's format property set to the matching format of the field. I want to use IIf for many different types of changes, and no matter what I try, it shows error. Gosh, somebody to talk to about access! Thanks

 

[TonTon]

What's the error that's displayed?

What version of Access are you using?

I am still using v2, but have read some of the documentation on "What's New" in later releases. I think that in one of the versions after v2, the IsNull function changed.

Hope this is of some help
Tony

Actually, looking again at this, I think your error may be because you have a circular reference. ie the control with the calculated field is referring to itself. Therefore it should not be called Amt. Good luck.

[This message has been edited by TonTon (edited 11-26-1999).]