I'm working with data from a table that may have a column with a null value. It seems to me the following line should test for that condition:

If IsDBNull(Books.Title) Then ...

But when the program encounters that line for a record with a null, it throws an exception: "The value for column 'Title' in table 'Books' is DBNull."

If I wrap the line with a Try/Catch, the exception is reported just before the line gets executed.

I've tried other ways of testing, like this:

If Books.Title.IsNullOrEmpty ...

But that doesn't seem to work for a strongly-typed variable.

Does anyone have suggestions?

Thanks,

Benn Gibson