J
Jonathan Scott via AccessMonster.com
I have three fields, only one of which is used, depending on external
criteria. I want to find which one is not null or not empty and display
that one.
My problem is, IsNull() and IsEmpty() will work on all three at any one
given time and always returns FALSE for each. Trying to perform an
operation on all of them, such as Len(), then results in an error.
How can VBA return FALSE for IsNull() and IsEmpty(), yet not let me perform
an operation on the field??? It seems there is some inconsistency within
VBA for performing such a simple operation.
Jonathan Scott
criteria. I want to find which one is not null or not empty and display
that one.
My problem is, IsNull() and IsEmpty() will work on all three at any one
given time and always returns FALSE for each. Trying to perform an
operation on all of them, such as Len(), then results in an error.
How can VBA return FALSE for IsNull() and IsEmpty(), yet not let me perform
an operation on the field??? It seems there is some inconsistency within
VBA for performing such a simple operation.
Jonathan Scott