WBS

S

Shannon

Hi,

I'm having problem of sorting a string
this is the way access will sort

1.2.3.1
1.2.3.11
1.2.3.2
1.2.3.3
1.2.3.4

I want it to sort like this
1.2.3.1
1.2.3.2
1.2.3.3
1.2.3.4
1.2.3.11
This is my code
x = Split(WBS, strDelimiter, , vbTextCompare)

i = UBound(x)
x(i) = CInt(x(i)) + 1
Me.txtWBS = Join(x, strDelimiter)

Please help, thanks
 
Top