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

It does! I think excel does it reversed?
 On Oct 25, 2011 11:59 PM, "Darren - Active Billing" <
darren at activebilling.com.au> wrote:

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