>>Thanks James. I was trying to skip this "intermediate" step (going to array) for the rowsource and simply use my view as the rowsource but I guess I can't.
>
>John,
>
>It may be that you can. I have never done it, favoring arrays as rowsources for most of my work. But maybe the view experts on this forum know of a way.
>
>regards,

One thing you can do, if it is a view you are using,
you can redefine the view :
...
select ..., left(mymemo, 30)as mytext, mymemo, ...
from ...

You can choose whatever length fits your combobox and you still have the entire memo in your view for updating, displaying memo contents, etc.

hth
Cheryl