Garry: What is the controlsource of the combobox? If it is an sql select order by the item you wish there. If you build the combobox with an array use asort(). If you popular with a table create an index on the field you wish. In a standard combobox when sorted is .t. it will sort on the first column and that is also true of the incremental search. Regards,
Jack Skelley ________________________________________ From: [email protected] [[email protected]] On Behalf Of Garry Bettle [[email protected]] Sent: Friday, March 05, 2010 8:19 AM To: [email protected] Subject: Combobox question ... Howdy all, Hope this finds everyone well - roll on the weekend. I'm trying to have a combo box with 2 columns, one hidden ( it's the key I want returned) and the other shown. The hidden key column would be something like: /horse-racing/2010-03-05/lingfield park/13-20/betting/ The shown column would be: 2010-03-05 13:20 Lingfield Park So, I thought in the Init of the combo I'd say: WITH this .ColumnCount = 2 .ColumnWidths = "0,150" ENDWITH And then set Bound = .T. and BoundColumn to 1. I'd also want the drop down to be Sorted, so I set that to .T. A sorted list would be something like: 2010-03-05 13:20 Lingfield Park 2010-03-05 13:50 Lingfield Park 2010-03-05 14:00 Doncaster 2010-03-05 14:10 Newbury 2010-03-05 14:25 Lingfield Park 2010-03-05 14:35 Doncaster etc. However, the sort doesn't work: the list is in course order ( it's populated in that order), not racetime. And the drop down shows the key as it's default item: it only missing you use select the drop down. Any ideas? Many thanks! Cheers, Garry _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0b957900b2b8194d998a441195b6603838f2b1e...@drdsrv03.drdad.thenewarkarena.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
