Sorting within Filter by Form

[Jutrased]

When using the Filter by Form a dropdown is created containing all the values for a particular field. In my case it is a text box field formatted for date. The dropdown list is sorted oldest to newest.

I know how to change the sort order of dropdown list on the actual form, but is there any way to change the order of the list on the Filter by Form? Instead of oldest to newest I would like newest to oldest.

 

[kjv1611]

I'm not positive off hand, but have you thought about creating your own custom control for the filter yourself? Then you can use VBA code and set the filter however you prefer.