Listview - sort

[Xkarlos77]

is there any way how sort the column with number ??
when I use sort I become :
1,
12,
3,
13,
.....
and i want :
1,
3,
12,
13.

thanks

 

[peekay]

That is the way the control sorts numbers - it sees it as text. You can overcome that by sorting the array (with a simple sort routine) and then writing it to the control. Otherwise you might sort the recordset with the SQL and then write to it (if you are reading from a database. PK Odendaal
pko@942.co.za

 

[Xkarlos77]

i want that the user can sort it by click on header.

 

[pkailas]

set at a field length and then add a leading zero.

 

[JohnYingling]

When I put FileSize into the ListView subitem, I right justify with leading spaces.
' Assuming 8 positions for size.
' Put 8 spaces on the left then take the rightmost 8 characters.
lstv.Items(idxSize) = Right$(Space(8) & CStr(marySize(I)), 8)

Now it will sort properly and look better in the list.

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript