I have a multi-column list box display and would like to show the first 20 characters of the contents of a memo field.

The SQL I created does pull the memo field when run in the Query area, but this memo field does not display when the SQL supports the list box.

Any insight into this mystery?

Karen

Why not use Left in the query?

Only20:Left([YourMemoField], 20)

As to the field not showing - have you checked the column count and widths?

Ooops, I found it. I added this information to my column count, but forgot to change the count.

Karen,

I was able to create a multi-column list box with the first 20 chars of a memo field being present using the LEFT SQL function.

Can you go into a little more depth with your problem?

Adam

Adam, my swimming fish ... my problem was that I added a column to the list box, but forgot to change the number related to what can be displayed. Problem solved and the memo field works OK.

Karen,

Excellent. And, to be honest, when I was trying to recreate your problem, I did the same thing

Adam