Showing a warning if a number exceeds a limit (1 Viewer)

[eacham]

Is it possible for a report to show a label that says that a number exceeds a limit. I thought you could do it using setvalue in the macros and making a condition and if the condition is met to make the labels visible property to yes, but I can't get it to work. Does anyone have any suggestions?

 

[Atomic Shrimp]

You could use a text box containing an expression such as:

=IIF([MyValue]>[MyLimit],"WARNING","")

HTH

Mike