> > > Turns out the problem is related to the database. Using code below: > > > > If objRs("SubText1") <> "" Or Not IsNull(objRs("SubText1")) Then > > blnSub1=True > > varSub1=objRs("SubText1") Why not check it in your SQL Statement? >=) Select ISNULL(SubText1,"value to use if its null") as SubText1 ... (MSSQL Server syntax above) sgd