Hello all,
I have several calculated textboxes on a form which take values from other textboxes in subforms. Many of them work fine, but a few display #Error when the textboxes they reference have no value. (Mainly when the form's navigated to a new record.) It really looks bad when an application has #Errors showing up all over the thing. I would prefer that they just be blank if such is the case. Any ideas how to alleviate this problem?
I have several calculated textboxes on a form which take values from other textboxes in subforms. Many of them work fine, but a few display #Error when the textboxes they reference have no value. (Mainly when the form's navigated to a new record.) It really looks bad when an application has #Errors showing up all over the thing. I would prefer that they just be blank if such is the case. Any ideas how to alleviate this problem?
Last edited: