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 :
But with this I get the following error message.
dim ls_myString as string
rsIplan = New ADODB.Recordset
rsIplan = MyAccessCon.Execute("SELECT * FROM table)
ls_myString = rsIplan.Fields.Item("CritProd").Value
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?