Detect Null Or Zero-Length Fields In A Database

This syntax is much faster than using an If.Then.Else construct to detectnull or zero-length fields, and it will ensure that an error will not occur.For strings:

 Dim sVar As String.sVar = "" & ds!sField

For numbers:

 Dim nVar As Integer.nVar = 0 & ds!nField

This assumes that ds is a dynaset and sField and nField are two fieldsin that dynaset.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: