• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Deal with NULL in access

Deal with NULL in access

By default Access string fields contain NULL values unless a string value (including a blank string like "") has been assigned. When you read these fields using recordsets into VB string variables, you get a runtime type-mismatch error. here is a nice code to get rid of that

Rate Deal with NULL in access

• 1
• 2
• 3
• 4
• 5

(6(6 Vote))

Dim DB As Database
Dim RS As Recordset
Dim sYear As String 
Set DB = OpenDatabase("Biblio.mdb")
Set RS = DB.OpenRecordset("Authors")
sYear = "" & RS![Year Born]
Just add a blank string to the returned field value.