Hi NG

I have two dropdowns, that sorts on IDnumber and IDtext...both ASC...
I made two queryes for the dropdown...
1 - with IDnumber in first colown in querybuilder - performing ok
2 - with IDtext in first colown in querybuilder - when I type some text with
startletter up to "k" the words shows up sorted fine in the dropdown, but
when I type startletter after "k" the words dont show up sorted in the
dropdown...

Anybody...

Thx in advance...
Bjarne
"Every day new surprises"

On Dec 20, 8:40*am, "bsn" <bsnSNABELAoncableDOTdk> wrote:
Is the rowsource sorted on the text field?

"Patrick Finucane" <patrickfinucanetx (AT) gmail (DOT) com> skrev i en meddelelse
news:e0932713-77db-4e84-8628-34e14525e830 (AT) v24g2000yqk (DOT) googlegroups.com...
On Dec 20, 8:40 am, "bsn" <bsnSNABELAoncableDOTdk> wrote:
Is the rowsource sorted on the text field?

----------------------------------------------
Yes...

Bjarne

On 20/12/2011 22:32:44, "bsn" wrote:
Have you got an illegal character in your IDText?

In your query, add Expr1:Ascii(IDText)

Create a function

Function Ascii(StgIn As String) As String

Dim i As Integer

For i = 1 To Len(StgIn)
Ascii = Ascii & Asc(Mid(StgIn, i, 1)) & " "
If If Asc(Mid(StgIn, i, 1)) < 32 Or Asc(Mid(StgIn, i, 1)) > 126 Then ' Space
to z Stop
End If
Next i

End Function
See if that shows up anything

Phil

"Phil" <phil (AT) stantonfamily (DOT) co.uk> skrev i en meddelelse
news:jcsbna$6dk$1 (AT) speranza (DOT) aioe.org...
Thx for answer
Yes I´v got 197(Ææ)+198(Øø)+216(Åå) - danish letters...
Can an illegal character do so, that the sorting/showing stops in the
(combo)dropdown...???
Bjarne

On 21/12/2011 15:47:48, "bsn" wrote:
That, I don't know.

Try making a copy of the table and eliminate those words with the Danish
letters and see if the combo works with the "cleaned up" table. That might at
least give you the cause of the problem, then we can try to find a solution.
Phil

"Phil" <phil (AT) stantonfamily (DOT) co.uk> skrev i en meddelelse
news:jct36q$2em$1 (AT) speranza (DOT) aioe.org...
Still the same problem...:-(
The query contains 140000 records...
U can see the case here : http://hoejbynet.dk/test/test.html
Bjarne

On 20/12/2011 22:32:44, "bsn" wrote:
Have you got an illegal character in your IDText?

In your query, add Expr1:Ascii(IDText)

Create a function

Function Ascii(StgIn As String) As String

Dim i As Integer

For i = 1 To Len(StgIn)
Ascii = Ascii & Asc(Mid(StgIn, i, 1)) & " "
If If Asc(Mid(StgIn, i, 1)) < 32 Or Asc(Mid(StgIn, i, 1)) > 126 Then ' Space
to z Stop
End If
Next i

End Function
See if that shows up anything

Phil

On 21/12/2011 15:47:48, "bsn" wrote:
That, I don't know.

Try making a copy of the table and eliminate those words with the Danish
letters and see if the combo works with the "cleaned up" table. That might at
least give you the cause of the problem, then we can try to find a solution.
Phil

Well the sorting on your example appears correct. Where does it go wrong? Can
you show an example of where it changes from being sorted correctly to wher
the sorting goes wrong Phil