Full Version: Listbox Issue
UtterAccess Forums > Microsoft® Access > Access Forms
sredworb
Hello,
Can't remeber how to set this one up...
When my listbox displays information, I have it set up to display Ascending order..
Problem I got is the info displayed is numbers...
So it displays, 1, 10, 11, 12 then 2, 3, 4,
Ocan't remember what to use so it displays, 1, 2, 3, 4, etc..
any help is always greatly appreciated...
Jerry..
theDBguy
Hi Jerry,

The problem is that your data is actually "text" and not numbers. You can sort them properly by converting them to numbers, such as:

Order

The problem is that your data is actually "text" and not numbers. You can sort them properly by converting them to numbers, such as:

ORDER BY Val([NameOfField])

Hope that helps...
sredworb
Thanks,
That did it.....
Jerry
theDBguy
You're welcome, Jerry. Good luck with your project.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.