Make Form Control Blank if Error

[Ganymede]

I have an unbound form control (From Control A) that is contains a dlookup formula. The dlookup formula references a bound form control (Form Control B). When I open the form to a new record, Control Form A returns an error because Form Control B is null. Can I program Form Control A so that it returns blank instead of an error while Form Control B is null?



I have been searching for a solution for over an hour to no avail.

First, I tried NZ, because I understand NZ has a built-in "Iferror" equivalent.

NZ([Form Control A formula), "")

But that returns an #error.

I also tried a combination of IIF and Not IsError.

IIF(Not IsError([Form Control A formula], [Form Control A formula], "")

That also returns in #error. I would greatly appreciate any advice.

[June7]

IIf() in Access requires all parts of expression can be evaluated, so since your DLookup can't, the IIf() itself returns error.

Nz() is not testing for error, it is testing for Null and returns alternate value if Null is read. Since DLookup returns error, not Null, Nz() fails.

IsError doesn't do what you think and won't work in an expression like that. Even if it did, your expression is missing a paren. Unfortunately, MS documentation for IsError seems to be less than clear on how to use. This discussion helped me understand better https://stackoverflow.com/questions/...eturning-error

Wrap reference to control B with Nz().

Show the DLookup expression.

[Gicu]

Fairly common topic:
https://answers.microsoft.com/en-us/...a-16f083d440a4
https://groups.google.com/g/comp.dat...4M56GaMs?pli=1
Wrapping the control B in Nz() should fix it.
Cheers,

[pbaldy]

https://theaccessweb.com/forms/frm0022.htm

[jojowhite]

show us the formula of the DLookup.

[Ganymede]

Thank you all for your responses. I attempted to multiquote everyone but couldn't get it to work. NZ worked liked a charm. Thank you all!