DropDown List Display

Ok maybe I am brain dead right now. I have a dropdown list. It contains 6
fields from a table. It must be a table and NOT an array because there are
too many elements (records x fields - about 14,000 records x 6 elements and
growing) for an array. The control is bound to column 6 (numeric). The
control displays the first 5 columns (text) when it is in dropdown mode. When
I select a row from the dropdown, it displays ONLY the data in column 6. I
want to display the data in the other 5 columns, not column 6

I have tried to play with the displayvalue but for the life of me, i cannot
figure it out.

Thanks in advance.

Dan
Thu Mar 30 15:29:35 CST 2006

Have you played around with .BoundTo?

Although I must say, I hope you don't ever get this working. As someone who
routinely uses software, I would vote for a very slow death for any
developer who puts 14,000 rows in a list object. That's just plain
user-hostile. <s>

Dan

Craig Farrel wrote:
> Ok maybe I am brain dead right now. I have a dropdown list. It
> contains 6 fields from a table. It must be a table and NOT an array
> because there are too many elements (records x fields - about 14,000
> records x 6 elements and growing) for an array. The control is bound
> to column 6 (numeric). The control displays the first 5 columns
> (text) when it is in dropdown mode. When I select a row from the
> dropdown, it displays ONLY the data in column 6. I want to display
> the data in the other 5 columns, not column 6
>
> I have tried to play with the displayvalue but for the life of me, i
> cannot figure it out.
>
> Thanks in advance.

CraigFarrel
Thu Mar 30 23:16:01 CST 2006

LOL...Well it was not me that did it, it was my client. You see, he requested
a list to populate the table from a supplier who supplied him with a list
much longer than was ever anticipated...LOL...no other client of mine is even
close to 3000, but this one insisted. I tried to talk him out of it, but you
know end users....

"Dan Freeman" wrote:

> Have you played around with .BoundTo?
>
> Although I must say, I hope you don't ever get this working. As someone who
> routinely uses software, I would vote for a very slow death for any
> developer who puts 14,000 rows in a list object. That's just plain
> user-hostile. <s>
>
> Dan
>
> Craig Farrel wrote:
> > Ok maybe I am brain dead right now. I have a dropdown list. It
> > contains 6 fields from a table. It must be a table and NOT an array
> > because there are too many elements (records x fields - about 14,000
> > records x 6 elements and growing) for an array. The control is bound
> > to column 6 (numeric). The control displays the first 5 columns
> > (text) when it is in dropdown mode. When I select a row from the
> > dropdown, it displays ONLY the data in column 6. I want to display
> > the data in the other 5 columns, not column 6
> >
> > I have tried to play with the displayvalue but for the life of me, i
> > cannot figure it out.
> >
> > Thanks in advance.
>
>
>