Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to handle DB Null
- Thread starter besto1a
- Start date
Try this:
If IsDBNull(Me.DsData.tbl_SocTar_ALL_SAP_AND_INFOPAC_COMBINED[red].Rows(count1).Item("Canc_date")[/red]) = True Then
I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson
Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Ye has a choice: talk like a pira
If IsDBNull(Me.DsData.tbl_SocTar_ALL_SAP_AND_INFOPAC_COMBINED[red].Rows(count1).Item("Canc_date")[/red]) = True Then
I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson
Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Ye has a choice: talk like a pira
- Status
