I've added sorting on my Report columns on click, alternating between ascending and descending. I'm using the same logic for 10+ columns and they work great except for one, which will not order by descending. The code I am using:
Private Sub Item_Description_Label_Click()
If Me.OrderBy = "[Item Description]" Then
Me.OrderBy = "[Item Description] DESC"
Else
Me.OrderBy = "[Item Description]"
End If
Me.OrderByOn = True
End Sub
When I debug, I can see that on the second click, since Me.OrderBy = "[Item Description]", the If statement evaluates to True and Me.OrderBy = "[Item Description] DESC" is reached. However, I see no difference in the actual Report. I'm stumped as I have another column with the same data type (long text) where both order bys work fine. Help would be much appreciated!