none
Combo Box order RRS feed

  • Question

  • I have a combo box that lists group numbers. I sorted them A to Z but it is displaying out of order. It lists 1 then 10 then 2, 3 ,4 and so on.

    How can I get it count correctly?


    C vivid

    Thursday, July 23, 2015 11:38 PM

Answers

  • Per your comment, I changed the group field in my table from a text to a number and that solved my issue.

    Thank you!!


    C vivid

    • Marked as answer by C Vivid Thursday, July 23, 2015 11:49 PM
    Thursday, July 23, 2015 11:49 PM

All replies

  • Hi,

    Sounds like the data is being treated as text rather than a number. If it's really text, then try using the Val() function to convert it to numbers.

    Thursday, July 23, 2015 11:42 PM
  • Per your comment, I changed the group field in my table from a text to a number and that solved my issue.

    Thank you!!


    C vivid

    • Marked as answer by C Vivid Thursday, July 23, 2015 11:49 PM
    Thursday, July 23, 2015 11:49 PM
  • Hi,

    Glad to hear you got it sorted out. Good luck with your project.

    Friday, July 24, 2015 12:05 AM