Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2004
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting problem (Access 97)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sorting problem (Access 97)

    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.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Jun 2004
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting problem (Access 97)

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •