Error with this IIf statement..

[Guest]

I am running Access 2k and am wondering why I would be getting an error with
this formula

=IIf([ProductLength]=0,[BlanksperSheet],[ProductWeight])

I have all the needed fields associated with the report that is pulling this
information. And if I tell the field just to fill in BlanksperSheet or
ProductWeight I get no error. I've got other IIf statements pulling using
the same arguement that work fine until I enter this one then one of them
stops working. Any help with this would be greatly appreciated.

 

[Brendan Reynolds]

Are you using this as the control source of a control that has the same name
as one of the fields referred to in the expression? If so, try changing the
name of the control.

 

[Guest]

Make sure that this formula is not located in a text box named "ProductLength"

 

[Guest]

It was actually that one of my text boxes was trying to pull information from
itself but your input and Brendan's helped me find this error. Thank you
both your help.

Make sure that this formula is not located in a text box named "ProductLength"

--
Good Luck
BS"D

I am running Access 2k and am wondering why I would be getting an error with
this formula

=IIf([ProductLength]=0,[BlanksperSheet],[ProductWeight])

I have all the needed fields associated with the report that is pulling this
information. And if I tell the field just to fill in BlanksperSheet or
ProductWeight I get no error. I've got other IIf statements pulling using
the same arguement that work fine until I enter this one then one of them
stops working. Any help with this would be greatly appreciated.