Memo field is truncated by query

[markb]

I am using a 'memo' field in a table because the field size needs to be more than the maximum for a 'text' field (255 characters).

Although the text appears in full in the table, when I run a query to select certain records from that table the text in the memo field is truncated to 255 characters.

Anyone know how to correct this?

 

[MicroE]

Maybe there links will help.

http://support.microsoft.com/kb/259893/

http://support.microsoft.com/kb/207668