Sunday, February 19, 2012

iif help please...

I want textbox2 value to NOT show if textbox1 has the word "***mail***"
<--just like that between the quotes.
Any help is appreciated.
Thanks,
TrintTrint,
Right click on textbox2, go to select properties, click the advanced button,
then select the visibility tab. click the 'Expression' radio button, then
put this text in the text box for the expression:
=IIF(Fields!FieldForTextBox1.Value.ToString() = "***mail***", False, True)
Fields!FieldForTextBox1 is whatever field from your datasource is populating
textbox1.
That sound do it for you.
"trint" wrote:
> I want textbox2 value to NOT show if textbox1 has the word "***mail***"
> <--just like that between the quotes.
> Any help is appreciated.
> Thanks,
> Trint
>|||That is it Jeff!
Thanks!
Trint|||no problem.
"trint" wrote:
> That is it Jeff!
> Thanks!
> Trint
>

No comments:

Post a Comment