I have a query, a field within the query is a memo field. When the query itself is ran, it returns the data in the field fo the records. however, I'm trying to put the data into a listbox on a form and the field is not showing. I think the issue is because it is a memo field and want to use "SQL CONVERT" but can't figure out exactly how to use it. Any ideas for:

Table: tblTask
Field: TaskDescription

I am sure the problem is that the memo field exceeds the 255 characters or so that the list box will display. Find out how many characters it will hold for each column, and then do this (assume it holds 20 characters):

SELECT Left(TaskDescription, 20) As Task
FROM tblTask

The user is probably going to make their selection on those first few characters anyway, and not look for text about 40,000 characters in.

Did that help?

mmcdonal

I actually switched it to a 'text' field instead of 'memo' field in the primary table, tblTask. I found out, through research, that fields with 'memo' properties cannot be displayed in listboxes without using a "SQL CONVERT" statement but couldn't find out exactly how I would word it for my situation. I only found examples of how to convert dates, times and numbers; not strings of words.

Oh well, it works now. Plus, I don't think that the field will go above / beyond 255 characters which is what I set if for.