Sorting records

[Samu77]

I've got a problem on access 2000, using vb6 about special character. If open the database and the table with access, I find database fields with special characters on the top. When I open a recordset with vb6, if I check if the first field is > of the last field, the answer is true. I'll make an example:
Access fields ( text fields ):
ART_E
ARTD
ARTE
VB6:
If "ART_E" > "ARTE" Then
Beep
End If
This kind of test is true but if I open access and the table, the sort visualizzed is another.


Someone have had the same problem?How can I solve it? Thanks.

[HiTechCoach]

II get this:

? "ART_E" > "ARTE"
False