Me.OrderByOn = True - Not working ??

  • Thread starter Thread starter Wayne-I-M
  • Start date Start date
W

Wayne-I-M

Hi

I have this on a simple continous form with
ClientID
Surname

It "should" sort on surname - but for some reason it only sorts the 1st 5
names. I could work it out if it just didn't work at all but this - I have
seen it before.

Any ideas - it's driving me mad :-)

Private Sub SortDownBut_Click()
Me.OrderBy = "[Surname]DESC"
Me.OrderByOn = True
End Sub

Private Sub SortUpBut_Click()
Me.OrderBy = "[Surname]"
Me.OrderByOn = True
End Sub
 
Hi

I have this on a simple continous form with
ClientID
Surname

It "should" sort on surname - but for some reason it only sorts the 1st 5
names. I could work it out if it just didn't work at all but this - I have
seen it before.

Any ideas - it's driving me mad :-)

Private Sub SortDownBut_Click()
Me.OrderBy = "[Surname]DESC"
Me.OrderByOn = True
End Sub

Private Sub SortUpBut_Click()
Me.OrderBy = "[Surname]"
Me.OrderByOn = True
End Sub
Click to expand...

You're missing a space between [Surname] and Desc

Try:
Me.OrderBy = "[Surname] DESC"
 
Fredg

You are a genius

Thank you

--
Wayne
Manchester, England.



fredg said:
Hi

I have this on a simple continous form with
ClientID
Surname

It "should" sort on surname - but for some reason it only sorts the 1st 5
names. I could work it out if it just didn't work at all but this - I have
seen it before.

Any ideas - it's driving me mad :-)

Private Sub SortDownBut_Click()
Me.OrderBy = "[Surname]DESC"
Me.OrderByOn = True
End Sub

Private Sub SortUpBut_Click()
Me.OrderBy = "[Surname]"
Me.OrderByOn = True
End Sub
Click to expand...

You're missing a space between [Surname] and Desc

Try:
Me.OrderBy = "[Surname] DESC"
Click to expand...
 
Back
Top