> I am accessing an Access database in VB using ADO. When I try to retrieve
> the value of a memo field, the program returns a null value even though
> Access memo field contains a string. When I use a watch expression on that
> field I notice that it contains the string value for a short period of
time
> and then changes to Null for no apparent reason. Is this a bug with
Access,
> VB or ADO.

> I get this problem only with the memo field in Access.

> Hope this can be solved.

> Thanks in advance.

> Greg

>i've got a similar problem with memo fields using access97 and vb6 and ADO.
>My table has a memo field, and a numeric field.
>i can delete a record from that table, i can add a record to that table,
but
>i can't update the memo field value (in any record) to a null value: i can
>edit the content of the memo field, but not give it the null value ("").
>In field properties, the memo field has its "allow zero length" property
>set to 'yes' and its "required" property set to 'no'

>As greg, i wonder if there is a bug involving VB6, ADO, and Memo field in
>access97.

>any clue, explanations, solutions or help  welcome.
>thanks in advance

>julien

>> I am accessing an Access database in VB using ADO. When I try to retrieve
>> the value of a memo field, the program returns a null value even though
>> Access memo field contains a string. When I use a watch expression on
that
>> field I notice that it contains the string value for a short period of
>time
>> and then changes to Null for no apparent reason. Is this a bug with
>Access,
>> VB or ADO.

>> I get this problem only with the memo field in Access.

>> Hope this can be solved.

>> Thanks in advance.

>> Greg