[AccessD] Value List ListBox retuning Null instead of one of its Columns

Hi William

As you one row only, the row parameter is of no use.
So:

?lstCompany.Column(0)
001005065
?lstCompany.Column(1)
HOLLISTON MILLS INC
?lstCompany.columncount
 2
?lstCompany.rowsource
001005065;HOLLISTON MILLS INC

If you insist:

?lstCompany.Column(0,0)
001005065
?lstCompany.Column(1,0)
HOLLISTON MILLS INC

/gustav


>>> vbacreations at gmail.com 26-10-2011 03:20 >>>
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!!!