MS Access memo field

[roobes]

Hi. I used a memo field to enter longer comments in an access database. Looking at the results in the table now, I've found that longer comments are cut off with "...". I've tried viewing it through a query and exporting it to excel but I can't seem to retrieve what was initially entered in that field in the form. The version is Access 2003.
Any ideas?
Thanks

 

[shellig]

Have you tried a form with a really big window? I did that (but that is where I input my really long text) and was able to see all that I put in when I could not see it in the datasheet or Excel (Only 1,024 characters display in a cell)
Access specifications say: Number of characters in a Memo field 65,535 when entering data through the user interface;
1 gigabyte of character storage when entering data programmatically

 

[PGoRule]

You will get all the text present in memo by exporting it to text(*.txt).

Sharing the best from my side...

--Prashant--