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.