Avoiding "#Error" in a form field (1 Viewer)

[giedrius]

Hello,

I have an Iif formula in my control, which checks for certain value entered in another field and then makes some calculation. However before this another field is filled in my form displays "#Error" in the control. How do I get rid of this annoying #Error?

Thank you for any advise.
giedrius

 

[SimpleDave]

Put your iif statement into another iif statement which checks for and handles the IsEmpty(otherField) condition.

 

[giedrius]

OK, thanks. But what if I need to check on a number of fields? I tried using another hidden field which holds a concatenated value of say other 3 fields which values should be tested, but is there a possibility to test the result of my very control for #Error and then take an action?

giedrius

 

[Rich]

Look up the Nz function

 

[giedrius]

After some experimenting I found out that you can concatenate in a separate invisible field all the fields to be tested with the "+" rather than with "&". This gives you null value result even if a single field is null. You then test for null value in that invisible field.

giedrius