Combo Box text limitations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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.
 
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.
 
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]
 
Back
Top