Reverse sort - Me.OrderByOn = False/True

[Wayne-I-M]

Me.OrderBy = "[ControlName]"
Me.OrderByOn = True

will sort by the letter of the control or numbers

How do you reverse the sorting

Me.OrderBy = "[ControlName]"
Me.OrderByOn = False

just removes the sorting

say you have

Mr Apple
Mr Pear
Mr Cheery

Sort on =
Mr Apple
Mr Cheery
Mr Pear

I am looking for
Mr Pear
Mr Cheery
Mr Apple

not just to remove the sorting but to revers it (Z to A)

Any ideas would be really helpful

Thanks

 

[John W. Vinson]

not just to remove the sorting but to revers it (Z to A)

Use

Me.OrderBy = "[ControlName] DESC"

to sort in descending order.

 

[Wayne-I-M]

Thank you John


--
Wayne
Manchester, England.

not just to remove the sorting but to revers it (Z to A)

Use

Me.OrderBy = "[ControlName] DESC"

to sort in descending order.