How much of your memo field is making it in? Have you checked the formula bar for the cell(s) in question? You can copy the text, open the immediate window of Access (CTL+G), and typeLength of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
?Len("my copied text")