Memo field in recordset changes to null

[Guest]

Hi,

funny problem that has me stumped code snippet below explains i hope

rs.Open (sql) ' sql is a select of a memo field from an access database,
code is in excel 2003 using ado 2.5

if i have a watch on anything that accesses the memo type field then at this
point in the code the field contains the expected data

mf = rs.Fields("Title") 'this is the memo field within the recordset

but, when the code executes the mf = .... line the recordset field is now a
null.

If i convert the field in the table in access to type text, length 255, it
is ok

has anyone seen this problem ? or even better got a workaround ?

thanks