Memo Truncating on Form

[andysgirl8800]

I searched the forum and realize that there are many posts on this subject, mostly related to exporting the data on reports and such. However, the problem that I am having is within the form. I have two memo fields on my form, named Memo1 and Memo2. Their data source is on a table where both fields there are also memo fields, called Notes and More Notes. I know a memo field can contain up to 65,000 characters, but mine don't seem capable of this and are truncating the data without warning the user, resulting in notations getting "lost". However, when I open the table that the form is bound to and check the Notes field, it DOES contain all the right data PRIOR to truncating. What's happening here? I've reviewed RG's link and have verified that I am not formatting or sorting on these fields, and I've utilized the ZOOM function, and I've checked the names of my fields. The form is built directly from the table, not a query, so I can't understand why this is happening. Starting to get very frustrated. Any suggestions would be welcome. Thanks for your advice.

 

[statsman]

On your form, try changing the Property for the Memo field - Can Expand - to yes

 

[andysgirl8800]

Fixed it.

So I messed around with the fields, ended up re-naming them several times, and somewhere in the middle of all that, was able to fix the problem. Nearly all users can now type a note worthy of a encyclopedia entry without worry and can view these lengthy memos with the zoom function. I do, however, have ONE user who cannot double-click on the fields to open the zoom box. Somehow, it just refuses to work for her. I've checked the references, and they seem to be a go. Oh, well, perfection is but a goal to strive for. Thanks for your suggestion.