Search results

Hi, I want to use an IIf in a textbox in my report. I have the following code in the control source: =IIf([filmlijst.status]>2,"d","e") the error given is: invalid syntax, you may have entered an operand without an operator As I searched on this item, I don't really see the problem...

Hi I want to color my text based on a criteria. If the status (a field in table) is for example '1', then it should be in normal black color. If it's '2', it should be in green. '3' should be in red. As I'm not familiar with the reporting stuff, I don't seem to get it to work. thanks in...