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

Darren - Active Billing darren at activebilling.com.au
Tue Oct 25 22:58:21 CDT 2011


Hi William
The no of columns in the property sheet of the list box is critical in this
scenario
If you have the number of columns set to one then access interprets each
delimiter (In this case semi-colon) as a new record rather than a new column
of the same record.
e.g. 001005065 becomes column 1 of record 1
HOLLISTON MILLS INC becomes column1 of record 2 instead of being column 2 of
record 1
Hope this helps
Darren


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson
Sent: Wednesday, 26 October 2011 12:20 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Value List ListBox retuning Null instead of one of its
Columns

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!!!
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list