control source expression

[ADDI BOOGALOO]

i am trying to display a field on a report as long as another field on that report matches a specific value. How can i do this.

Any examples would be greatly appreciated.

 

[KevinM]

OnFormat Event....

If [MyField]= etc etc Then
[MyUnboundField].Visible=True
Else
[MyUnboundField].Visible=False
End If

HTH

 

[Chris RR]

You could create a new field in the query underlying a report, like this:
NewField=Iif([TABLEA]![MyField] ="X", [TABLEA]![MyOtherField] ," ")

You could put similar Iif code into the Control Source of a report field, if you'd rather do that.