text field to appear only if source value is "Yes"

[Guest]

I have a text field that I want to appear on my report only if it's source
value is "Yes." The text field name and control source is "FoodContact." The
control source is a combo box with a vlaue list of "Yes" and "No."

How can I achieve this?

Thanks in advance for your kind support.

 

[Al Camp]

John,
In the query behind the report, in the FoodContact column, use a Criteria
of...
="Yes"
Now only Yes FoodContacts will be returned by the report.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Guest]

Thanks, Al.

I tried your suggestion but then records that have "No" as a value don't
appear. I simply want the text field to appear if the value is "Yes." If the
value is "No" then that text field doesn't need to appear, however, the rest
of the record does.

Maybe I can achieve this through the control's control source? I tried the
following but it returns an "#Error."

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

Do you see what's wrong?

Thanks!