Hello,

I have a problem reading a memo field from a access DB.
When I change the field from memo to a text field, I can read it whithout any problems.

This is part of my code :
Code:
dim ls_myString as string
rsIplan = New ADODB.Recordset
rsIplan = MyAccessCon.Execute("SELECT * FROM table)
ls_myString = rsIplan.Fields.Item("CritProd").Value
But with this I get the following error message.
Conversion from type 'DBNull' to type 'String' is not valid.

I already changed the .value to .tostring but it remains the same.
Can anyone help me solving this issue?

Thank you
Christophe