ldbryant55
New member
- Local time
- Today, 11:52
- Joined
- Oct 18, 2018
- Messages
- 8
Hello, I'm stumped. I have a drop down combo box in a form that lists projects by number, pulled from a project number field in the base table. It used to list the numbers in order, 1, 2, 3, etc., all of a sudden, it is now listing them like this: 1, 10, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 11, 110, 111, 112, etc. (see the pattern?)
I've tried several solutions, including adding an SQL "ORDER BY ProjectNumber", reformatting the field in the original table, reformatting the field in the form, etc. Right now, the field in the table is set as an integer, and the field in the form is set to format "blank". Like I said, I've tried all kinds of combinations, (standard, fixed, general number, etc.), but it still sorts the same way. What can I do to fix this?
I've tried several solutions, including adding an SQL "ORDER BY ProjectNumber", reformatting the field in the original table, reformatting the field in the form, etc. Right now, the field in the table is set as an integer, and the field in the form is set to format "blank". Like I said, I've tried all kinds of combinations, (standard, fixed, general number, etc.), but it still sorts the same way. What can I do to fix this?