IIF Statement Do Nothing in Else Section

EtherealNoise

I'm trying to figure out how to make an if statement do nothing in the else section of an IIF statement. 

Example: IIF(Length([Column5])>40, "color: red;", "color: black;")

I've noticed if I keep the color: black; in else then that could override another validation rule that colored it red previously. So I want it to either color it red or do nothing. I don't want it to make it black. I've also seen suggestions saying to use the [Column5] again in the else but then it's just rewriting the data without any other formatting, which is basically just saying color: black;. 

I've also seen Null() as a solution and while that has helped I've seen some instances of it coloring it red even when it's not supposed to when Null() is there. It's supposed to be black but it's red then when I switch it back to color: black; instead of Null() it sets it to black correctly. So Null() is a little unpredictable.

FrederikE

Hey @EtherealNoise,

Can you provide an example where this doesn't work: 

"I've also seen Null() as a solution and while that has helped I've seen some instances of it coloring it red even when it's not supposed to when Null() is there. It's supposed to be black but it's red then when I switch it back to color: black; instead of Null() it sets it to black correctly. So Null() is a little unpredictable."

This should certainly not be the case, and if it is, it would be a bug.  There is very likely an other reason (Meaning the condition is met) if this doesn't result in a Null. 

In General, if the column already pre-exists before your statement, just refer to the column itself. If it doesn't, Null() will do.