June 12, 200421 yr I have several numbered lists of information that are value lists in my database. When the popup lists are displayed in any given field, they by default are alphabetized resulting in out-of-sequence numbering: 1. Item 1 10. Item 10 11. Item 11 12. Item 12 2. Item 2 3. Item 3 4. Item 4 5. Item 5 6. Item 6 7. Item 7 8. Item 8 9. Item 9 Is there a way to have my numbered lists displayed without being alphabetized, so they are in the proper numerical order?
June 12, 200421 yr You can use another field and sort on it. Value lists are made from the index and are always sorted. They are also text and the text sort is what you see. If you used text instead of numbers you could use 01, 02, 03, 04, ... 10, 11, 12.
Create an account or sign in to comment