Sorting problem (Access 97)

Topic

New Reply

I have a combo box and a list box on two separate forms which have alphanumeric data.
An example of the data is:
ABC0401
ABC0201
3ER0401
3ER0201
The combo box sorts the data into ascending order starting with the numbers and then the letters, but the list box sorts them into descending order starting witht eh 4th character in the data. I want it to sort like the combo box. Any help?

Thanks,
Nick

Reply | Quote

Replies

Listboxes and comboboxes don’t sort anything. The sorting is done in the rowsource for the control. If the sort is different, then you can’t be using the same rowsource. A bit more detail will help you get a more specific answer.

Reply | Quote

thanks

Reply | Quote

thanks

Reply | Quote

Listboxes and comboboxes don’t sort anything. The sorting is done in the rowsource for the control. If the sort is different, then you can’t be using the same rowsource. A bit more detail will help you get a more specific answer.

Reply | Quote