Adding a 3rd condition in IIf(IsNull expression

[Holli]

I have no idea how to do this. I have been asked to add another condition to my IIf(IsNull expression

=IIf((IsNull([Coding Errors])) And (IsNull([MM Changes after WF])),"","Field Required")

Thanks Joe M. works great.

My task now is to add the Notes textbox to the condition and if Notes are present then the message will read Notes are present in blue


Any direction would be of great help.

Thanks

Holli

[ranman256]

IIF statement is for a query,
this is on a form, so I would remove the IIF and use this code in an event:

public sub TestFlds()
    if IsNull([Coding Errors]) And IsNull([MM Changes after WF]) then
            txtBox = ""  
    else
           txtBox = "Field Required"
    end if 
end sub

[June7]

This is an expression in Conditional Formatting?

If you want to change text or back color, need to use Conditional Formatting.