Hello Everyone,
Any idea how to modify a filter order? The filter order seems to default to alphabetically no matter what order is used in the lookup values. I am trying to have the filter default to a list option named “None” but unfortunately it is not the first option alphabetically. Any ideas? I’m using Excelcius 2008.
cmn135 (BOB member since 2009-06-08)
The filter component does not seem to have that option.
But if you must absolutely change the default value, one work around is to use a combo box instead of filters. And then in the combo box you would select the default value you want to display.
Yes, this would mean multiple combo boxes and more work depending on the number of filters you have.
Also, if you find out a way to change the order in the filter directly do let us know.
Naresh Ganatra 
(BOB member since 2004-04-09)
Ok i’ll pass along if I can figure it out. Thanks Naresh.
cmn135 (BOB member since 2009-06-08)