Combo Box text limitations

P

PD

I am using a combo box to display query results from a memo field on a table.
It appears to cut off text. What is the limitations on this and how can I
get it to display all of my text?

Thanks,
 
D

Douglas J. Steele

If you're sorting on the memo field or if you're applying any function to
it, then it will be truncated to 255 characters.
 
D

Douglas J. Steele

The truncation has nothing to do with the fact that it's a combo box. If
you're sorting on the memo field or applying a function to it, the value of
the field in the query will be truncated.
 
J

John W. Vinson

The truncation has nothing to do with the fact that it's a combo box. If
you're sorting on the memo field or applying a function to it, the value of
the field in the query will be truncated.
Click to expand...

Well, *in addition to that fact*, including a memo field in a Combo Box will
truncate it. You cannot pass a memo field from a table to a textbox via a
Column() property of a combo box... period.

You would need code to retrieve the memo from the table (using DLookUp or a
recordset), based on some unique value selected in the combo.

John W. Vinson [MVP]
 
Top