Alphabetical sort orders.

[dawkirst]

Hello.

How can I preserve the user-defined sort order in a column in a table?

Every time I exit the table, and go back, my items have been alphabetically sorted. This results in my Combo Box displaying the list in alphabetical order, rather than my custom order.

Thanks ahead.

 

[neileg]

There is an order by property in the table property sheet. Have a look here.

However, it is better practice to base your combo on a query, and you should impose you order in the query, not the table.

 

[ChubbChubb]

I also wanted to implement a user-defined sort order, and found step-by-step instructions for how to do it at Microsoft Help and Support:

ACC2000: How to Create a Custom Sort Order

...worked as advertised in Access 2002. Hope this helps somebody!