VBA, combobox doesn't work w/Unicode

combobox doesn't work w/Unicode

Author	Message
Jerem #1 / 4	combobox doesn't work w/Unicode I have a combobox that displays foreign language (classical greek) data using a unicode font. The problem is that when the user types into the combobox to limit which rows are displayed it acts as if there is a preceding wildcard "" in addition to the traditional trailing "". In other words the sql where expression would be: like "" & combobox.text & "". This makes it difficult to use. Is there any way for this to work in a non-roman alphabet like greek? It shouldn't have anything to do with the sort order should it? I've also tried to limit listboxes based on the criteria in a text box and it does exactly the same thing when the data is unicode classical greek, but performs as expected when the unicode data is english. thanks for your help, Jeremy
Sun, 07 Aug 2005 14:50:59 GMT

michk #2 / 4	combobox doesn't work w/Unicode You have not specified the version of Access, the OS version you are using, the OS language, the sort order of the database, an example of the records that are being retrieved by mistake, the font being used in the control, or an example of the actual characters you are searching with. This makes even guessing what may be going on difficult. -- MichKa [MS] This posting is provided "AS IS" with no warranties, and confers no rights. Quote: > I have a combobox that displays foreign language > (classical greek) data using a unicode font. The problem > is that when the user types into the combobox to limit > which rows are displayed it acts as if there is a > preceding wildcard "" in addition to the traditional > trailing "". In other words the sql where expression > would be: like "" & combobox.text & "". This makes it > difficult to use. Is there any way for this to work in a > non-roman alphabet like greek? > It shouldn't have anything to do with the sort order > should it? I've also tried to limit listboxes based on > the criteria in a text box and it does exactly the same > thing when the data is unicode classical greek, but > performs as expected when the unicode data is english. > thanks for your help, > Jeremy
Sun, 07 Aug 2005 14:55:51 GMT

Jerem #3 / 4	combobox doesn't work w/Unicode Thanks for the reply, sorry I was so vague. I'm using Access 2000 on WinXP Pro. The font is the Palatino Linotype Unicode font that comes with winxp. The os language is English. An example of the error would (using english strings for the sake of example) the user types "g" into the combobox. But instead of the combobox narrowing down its rows to words that begin with "g" it shows all words that _contain_ a "g" anywhere in them. This happens when using strings made up using the Classical Greek portion of the palatino linotype font. My other comboboxes that use the English portion of the font work as expected. Thanks again for any help you can offer, Jeremy Quote: >-----Original Message----- >You have not specified the version of Access, the OS version you are >using, the OS language, the sort order of the database, an example of >the records that are being retrieved by mistake, the font being used >in the control, or an example of the actual characters you are >searching with. This makes even guessing what may be going on >difficult. >-- >MichKa [MS] >This posting is provided "AS IS" with >no warranties, and confers no rights. >> I have a combobox that displays foreign language >> (classical greek) data using a unicode font. The problem >> is that when the user types into the combobox to limit >> which rows are displayed it acts as if there is a >> preceding wildcard "" in addition to the traditional >> trailing "". In other words the sql where expression >> would be: like "" & combobox.text & "". This makes it >> difficult to use. Is there any way for this to work in a >> non-roman alphabet like greek? >> It shouldn't have anything to do with the sort order >> should it? I've also tried to limit listboxes based on >> the criteria in a text box and it does exactly the same >> thing when the data is unicode classical greek, but >> performs as expected when the unicode data is english. >> thanks for your help, >> Jeremy >.
Sun, 07 Aug 2005 15:15:06 GMT

Jerem #4 / 4	combobox doesn't work w/Unicode I forgot to address sort order. I'm using the "General" sort order. I didn't see a sort order for unicode classical greek (or even modern Greek, though I don't think that would work anyway) so I have a special field in each Greek record that represents the greek in Roman characters just for the purpose of alphabetizing. If there is a better way to do this I'd be grateful. Jeremy Quote: >-----Original Message----- >You have not specified the version of Access, the OS version you are >using, the OS language, the sort order of the database, an example of >the records that are being retrieved by mistake, the font being used >in the control, or an example of the actual characters you are >searching with. This makes even guessing what may be going on >difficult. >-- >MichKa [MS] >This posting is provided "AS IS" with >no warranties, and confers no rights. >> I have a combobox that displays foreign language >> (classical greek) data using a unicode font. The problem >> is that when the user types into the combobox to limit >> which rows are displayed it acts as if there is a >> preceding wildcard "" in addition to the traditional >> trailing "". In other words the sql where expression >> would be: like "" & combobox.text & "". This makes it >> difficult to use. Is there any way for this to work in a >> non-roman alphabet like greek? >> It shouldn't have anything to do with the sort order >> should it? I've also tried to limit listboxes based on >> the criteria in a text box and it does exactly the same >> thing when the data is unicode classical greek, but >> performs as expected when the unicode data is english. >> thanks for your help, >> Jeremy >.
Sun, 07 Aug 2005 15:25:56 GMT

Page 1 of 1

[ 4 post ]