more #Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text field [FoodContact] that I want to appear only if it's value is
"Yes." I can't seem to work this out. Here's the control source I'm using,
however, it returns the dreaded #Error.

=IIf([FoodContact]<>"Yes",Null,"")

Can anyone help, please? Thanks!
 
Is FoodContact a text field with a possible value of "Yes" or is it a YesNo
field?

Make sure the name of the text box is not also the name of a field.

Regardless of the value of FoodContact, you won't see any value displayed on
your report.
 
Thanks, Duane. I corrected it accordingly. I had another brain cramp!
--
www.Marzetti.com


Duane Hookom said:
Is FoodContact a text field with a possible value of "Yes" or is it a YesNo
field?

Make sure the name of the text box is not also the name of a field.

Regardless of the value of FoodContact, you won't see any value displayed on
your report.

--
Duane Hookom
MS Access MVP


JohnLute said:
I have a text field [FoodContact] that I want to appear only if it's value
is
"Yes." I can't seem to work this out. Here's the control source I'm using,
however, it returns the dreaded #Error.

=IIf([FoodContact]<>"Yes",Null,"")

Can anyone help, please? Thanks!
Click to expand...
Click to expand...
 
Back
Top