Trying to use IIf(Is Not Null expression in control source

[Holli]

Thanks for any direction. Trying to use =Iff(Is Not Null


I have a =IIf in the control source of a textbox. It works great with IIf (IsNull

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

.

"Field Required" shows up in the textbox if the textboxes are empty I need "Field Required" if there is a value
present.



Thanks

Holli

[JoeM]

You have written it so that "Fields Required" shows up only if both values you are checking for are Null (empty).
If you want it to show up if a value is present for either field (or both), you could use:

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

If you want something else, please describe what you want in each situation (if none are null, one is null, both are null).

[Holli]

Thanks Joe,

I have Is Not Null stuck in my head. Maybe I not thinking correctly.

If there is a value in the textbox Error Coding and/or MM Changes after WF, then I would like the Note Text Box to read "Required Field". If no value the Note textbox should remove blank.

Right now with the IsNull the Note TextBox reads "Required Field" when Error Coding and MM Changes after WF are empty.

Thanks

Holli

[JoeM]

I think you are still confusing us here. Let's break this down into each situation:

- What should be returned if [Coding Errors] is Null and [MM Changes after WF] is Null?

- What should be returned if [Coding Errors] is Not Null and [MM Changes after WF] is Null?

- What should be returned if [Coding Errors] is Null and [MM Changes after WF] is Not Null?

- What should be returned if [Coding Errors] is Not Null and [MM Changes after WF] is Not Null?

[Holli]

Sorry,

Thank you for the format.

What should be returned if [Coding Errors] is Null and [MM Changes after WF] is Null? Nothing Blank

- What should be returned if [Coding Errors] is Not Null and [MM Changes after WF] is Null? Field Required

- What should be returned if [Coding Errors] is Null and [MM Changes after WF] is Not Null? Field Required

- What should be returned if [Coding Errors] is Not Null and [MM Changes after WF] is Not Null? Field Required

Holli

[JoeM]

The formula I posted up in post #2 should do exactly that.
Have you tried it?

[Holli]

Sorry for the daily.
Thanks JoeM perfect.

Holli