Null To Nullstring From Recordset To Array

  • Hello All,

    I am trying to move information from a recordset to an array. Some of the values in the recordset are null. The array holds strings. When I try to move all the values over, I get an error: "Invalid Use of Null" when I get to a null value - even when the data in the underlying table is text. I don't understand why an empty text field in the table would not move into the recordset and an array as nullstring. What's behind this error? Is there a difference between text in an Access table and a string in VB? Anyone know what I'm doing wrong here?

    All help is appreciated.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!