If then display problem

[cmartin19]

How should this go:

Code:
IF {table1.field1}="Y" Then "Text"
/Code

I want the text to display if the field value is "Y" . I know that this should be a Y/N field, but nonetheless the field is still displaying "Y"

I just can't see mto get over the hump on this one.

Thanks

 

[RichO]

You want a "Y" to display if the field value is "Y", otherwise nothing?

You can put this expression right in the control source for your text box:


=IIf(Table1.Field1 = "Y", "Y", "")

 

[cmartin19]

not really,

I want a text string to appear if there is a Y in the field.

str("additional requirements")

does that clear it up? Sorry I was so vague before.

 

[RichO]

"IIf" is very easy to use and very useful. You can change it to whatever you need it to do. The syntax is:

IIf(Condition, If True, If False)

So if you want a string to print if your field contains a "Y" and nothing to print if not "Y"...

=IIf(Table1.Field1 = "Y", "Additional Requirements", "")

 

[cmartin19]

Thanks that got it.