Query a memo field

[PrimaryHealth]

Greetings All -

Let me say first I am a novice Access user, just trying to teach myself a few things to make my job easier. So take it easy on me with any feedback.

This is my situation. I am using a web based help desk ticketing software that has an Access DB. I have created a couple of queries and linked them together that seem to be working and giving me the data that I want with one exception.

I am tring to query a memo field, which is the description of a ticket, and the output is only a small portion of what is actually entered in to the table. Is there a way either in my query or report builder to make a change that will output all of the data from the description field?

A couple of things that I've tried on my own are to change the data type for that field from memo to text, however that that puts limits on the amount of data that can be entered in and causes the help desk software to function incorrectly. I've also turned on Can Grow and Can Shrink for the text box for the output in my form.

Any help you can offer would be greatly appreciated.

Thanks.
Jason

 

[mtairhead]

I had an issue similar to yours, but only 255 characters appeared in my memo field of my TABLE, not just my query. See, I had my tables linked to an Excel spreadsheet...And although there were pages of data per record in Excel, only the first 255 characters came through on my table.

Check out the source of the query. Do the tables (Assuming they're linked) actually have the entire memo text, are are they lacking too?

Check out this thread, if so:

It's how I finally solved my issue...

Andrew