Query sort problem (when set as recordsource in listbox)

[phxbypdx]

Hey All -

I'm running a sort (via command button) on the results of a query located in a listbox. I want to return only records in a field that are numeric, then sort asc/desc on that field. When I run this as a standalone query, it works fine (and I can toggle asc/desc no worries). When I run the query as a recordsource on a listbox, the data doesn't act as I'd expect... it treats my field as if its a text field. Here is the evaluation in the query:

RONum: IIf(IsNumeric([WF_RONum]),CInt([WF_RONum]),Null)

(I then set a criteria of <> "")
Further explanation...

Lets say I have the following 4 values: 543, 11356, 11357, 11358

Numerically sorting, they would display as follows:
543
11356
11357
11358

Text/String sorting, they would display:
11356
11357
11358
543

As I indicated... the query itself returns the first set of sorting (numeric), but the listbox returns the text sorting.

Any idea why? Or how to fix this?

Thanks,

Scott

 

[SOS]

Just use a separate field and go with

MySortField: Val([WF_RONum])

and then set the sort order and the criteria of

Is Not Null