View Full Version : control source expression


ADDI BOOGALOO
05-08-2001, 06:37 AM
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
05-08-2001, 06:46 AM
OnFormat Event....

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

HTH

Chris RR
05-08-2001, 10:34 AM
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.