William Benson
vbacreations at gmail.com
Tue Oct 25 20:20:27 CDT 2011
I have a listbox. It is ValueList rowsourceType. That rowsource is
001005065;HOLLISTON MILLS INC
I am trying to query the column property in order to get
HOLLISTON MILLS INC
but it is coming back as null
?lstCompany.Column(0,1)
Null
?lstCompany.Column(0,0)
001005065
?lstCompany.columncount
2
?lstCompany.rowsource
001005065;HOLLISTON MILLS INC
Can someone tell me if there is a different property I am supposed to use?
Nothing is selected in the listbox, it is a single-row listbox specifically
designed to hold a value in a hidden column (in this case '001005065') and
display the other value ('HOLLISTON MILLS INC') which it does wonderfully,
but it is not giving me access to the second column.
Note: I am very aware I can, since I know the rowsource, parse it and
retrieve the HOLLISTON MILLS INC part .. that is my current workaround. but
I would like to better understand what is going on.
Thanks!!!