Force Value to be last item in a dropdown list

[nortonm]

Hi - Is there a way of forcing a value in a listbox or combox to the bottom of the list, even though though the rest of the list is sorted a-z? It's a two box conditional combox thing, the list in Cat2 is selected from the Cat2 table depending on what was selected in Cat1 cbobox, so I can't just order the Cat2 table manually to achieve it. It's so users can select 'Other...' from a list if what they want isn't there.

The list will change and grow I imagine, won't be a fixed list I could just use as a value list instead. (I'll give users the facility to add/remove items on the list)

I wondered if you could force an item to last in query code or something?


Many Thanks for reading.

 

[Minty]

Add a "ordering" column. Set its value to 1 for everything except "other" set it to 2.
Now set your combo's row source sort order is by Ordering , YourText .

 

[nortonm]

Oh, lovely - thanks! I didn't think to do this using duplicate values, I was getting lost thinking about different numbers for each value. Simples!! Many Thanks

 

[isladogs]

And on a similar note you can force something to the top of the list either by using the same method or by adding a tilde (~) or a hash sign (#) at the start of the item name

 

[Mark_]

Prepending a space or two will also force to the top of a list. It has the advantage of being easy to remove. Or for those with a more fun mindset, try an ascii 1! ☺

 

[isladogs]

'Prepending' ....

Now that's a word you don't hear every day

 

[Mark_]

Well, you may append and you may prepend. One goes after the other though...