I have an Access app. on the front-end and SQL Server tables on the back-end. I have a Memo field (Content) in one of the table (tblCustomer). For some reason, sometimes after I entered data into this field as a new record from a form, the data keep dropping off when I moved to the next record or closed out the form. It doesn't happened all the time. All other information on the record are still there except for the content of the Memo field. The table confirmed my finding. I changed it to a text field and it still happenning. Can someone tell me why? Can someone tell me what to do?

Thanks in advance for all your help

John Pham