When I query on a memo field the query treats it like a text field and truncated the length to 255 characters. How can I get me query to treat the memo field like a memo field and return its entire contents?

I don't think a query will truncate a memo field.

You can view its entire contents in a report or form, using the query as record source.

Evidently when I first made the table, the field was a text field. I then made the query. I then went back and changed the field in the table to a memo. The query still treated it like a text field. I deleted the query and made a new one and it still truncated the field as if it were a text field. The report even truncated it using the query as a base. I did get around it by using Excel to pull the query data into a spreadsheet.