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.