Change ADO sorting order

[SGCS]

My Access database has normal English characters and extended characters like  and Ä in a text column. When I try to sort the column, I will get something like

txtCol
------
A...
Â...
Ä...
B...
...

Is there some way to change the sorting sequence and make the result look like

txtCol
------
A...
B...
Â...
Ä...

Any help is much appreciated. Thanks in advance.

[M Owen]

With sort orders there are only 2: Ascending (Z-A) and Descending (A-Z) ... What you might consider is another column with a numeric value associated with the display column that you assign to put in the order you wish ...