dissappearing memo data - from linked table

[dpimental]

All, I have a form based on a query from combined linked access tables and linked oracle tables. From time to time, we have data in a memo field that disappears.

Technically, it's just a text box, since the field is in a linked oracle table and there is no such thing as a "memo" field in oracle.

The field is a VARCHAR2 (4000 Byte) field.

Has anyone heard of this issue before or have a suggestion for a work-around?

David Pimental
(US, Oh)

 

[MajP]

When you say disappear, does it just not render in the query or is the data truly lost from the table after running the query?

 

[dpimental]

Sorry about not being clear. That's my colloquialism. Yes, the data is lost. I have a work-around; but I would rather solve the problem.

Any ideas?

David Pimental
(US, Oh)