listbox character limit

[john]

Is it possible to set it higher than the 255 limit, by code or otherwise.

 

[Douglas J. Steele]

What 255 character limit for listboxes?

 

[John Spencer (MVP)]

If you are referring to the max length for the contents of any one "cell" then
the answer is NO.

What are you trying to do? You can, for instance, use the selected row (and a
primary key - visible or hidden) to lookup the associated value and display data
related to the currently selected item in a textbox control. The textbox
control can display much more data, although for only one record.

So, tell us what problem you are trying to solve and perhaps someone can give
you a solution.

 

[john]

I actually have what is a working solution, so far as retrieving the full
text which is cutoff at 255 length, but it is much slower than just
referring to the column() of that listbox cell, because I have to get it by
going back to the RecordsetQuery, as it is an external database.

The Query is a saved query, just noticed a big slow down when I arrow down
thru the list box, then from before when I did not know the text was being
cut off.

I suppose I could split the text into a spill over cell and reassemble it, I
do similar operations like that on variables with good performance. Just
thought there might an easy option or code instead.

Open any ideas though

Thanks John