Hello,

It may be worthwhile using a sort in the ADO rather than the list box. Set
recordset with a SQL statement such as SELECT * From Authors Order By ...

This may even be the reason why you are getting a sort error.

Hoping this will help,

Richard Wang

----- Original Message -----
From: Fredrick J. Krantz <krunch97@m...>
To: professional vb <pro_vb@p...>
Sent: Thursday, May 25, 2000 1:13 PM
Subject: [pro_vb] list box sort


> Getting incorrect results in list box when setting sorted to true.  If
> false all elements loaded are in box, if I switch it to true the last 4
> elements are not listed correctly.  The last 4 elements are a copy of the
> 1st element and 3 others in the list box.
>
> Any ideas, solutions in list box or is it a bug in VB6  I know I could
just
> pull up all elements in sorted order then load them into the list box but,
> it doesn't fix the problem with the list box.
>
> Thanks.
>