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.