How do you use conditions that say if is not Empty continue otherwise skip.
I tried using r.fields(0) <> Empty continue otherwise skip. But is not working when is Empty it continue too.
Please advise.
How do you use conditions that say if is not Empty continue otherwise skip.
I tried using r.fields(0) <> Empty continue otherwise skip. But is not working when is Empty it continue too.
Please advise.
If r.fields(0) & "" <> "" Then
Will deal with both Null and empty string.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
The IsEmpty() function only applies to variants.
Thank you to both of you for clarifying.