13

I want my textbox to have an action ONLY if the condition is true, otherwise no action. This is what I have as my current action expression for going to another report:

=IIf(Fields!MyTextbox.Value = "0", "Report2","")

This does not produce my desired result. It gives the textbox an action regardless of the condition result. Is there a 'No Action' or 'Cancel Action' value?

Preet Sangha
  • 64,563
  • 18
  • 145
  • 216
Jesse
  • 2,043
  • 9
  • 28
  • 45

1 Answers1

26

The null keyword in VB is Nothing:

=IIf(Fields!MyTextbox.Value = "0", "Report2", Nothing)
Jesse
  • 2,043
  • 9
  • 28
  • 45