You will see this type of runtime error 94, invalid use of null in application that uses ADO to connect to an Access database. Some of the entries in the recordset are blank and these seem to be giving me problems. I keep getting the error “runtime error ‘94‘, invalid use of null” error. Text boxes hold values as strings and string variables cannot hold NULL values.

Example line that causes error:
txtCompanyName.Text = frmCustomers.AdodcCustomers.Recordset.Fields(”CompanyName”)

change it to

txtCompanyName.Text = frmCustomers.AdodcCustomers.Recordset.Fields(”CompanyName”) & “”

this will fix every NULL problem

good luck

Popularity: 4%