On Oct 30, 2004, at 11:58 PM, Kim Kohen wrote:
Is there a way to change it to true numeric sorting
Yep. Put something like this in the CompareRows Event:
if column=1 then //this assumes your numbers are in column 1; adjust
accordingly
if val(me.Cell(row1,column)>val(me.Cell(row2,column) then
result=1
else
result=-1
end if
return true //this tells RB that you've handled the event and no
longer need its help :)
end if
--
brad at truetech dot org
http://truetech.org
<><
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://www.realsoftware.com/listarchives/lists.html>
|