Solved Confusing Combo-Box requirement...

prabha_friend

Prabhakaran Karuppaih
Local time
Today, 05:34
Joined
Mar 22, 2009
Messages
1,037
it's a Multi-column ComboBox having the following Data as Columns:
217 Dhathri Herbal Oilதாந்தரி ஹெர்பல் ஆயில்
218DND டிஎன்டி
219Domex Fresh Guard Lime Freshடோமேக்ஸ்

When the User starts Typing the English value we need to show the Tamil value
User Types: Dha
ComboBox Suggests: தாந்தரி ஹெர்பல் ஆயில்

Possible?
 
Possible?
Not really.

You would have to concatenate the values (use 2 columns instead of 3).

ControlSource would be:
SELECT ID, [EnglishField] & " - " & [TamilField] FROM YourTable
instead of:
SELECT ID, [EnglishField], [TamilField] FROM YourTable

But I don't know whether there would be a problem displaying both English and Tamil together from a font perspective.
 
It should be possible to output the content of column(2) - the Tamil version - to a textbox.
However, you may have to wait until typing has completed.
Try something like this, substituting the name of your combo and the textbox

Code:
Private Sub ComboName_AfterUpdate()
   Me.TextboxName= Me.ComboName.Column(2)
End Sub
If that works, then you can adapt find as you type code to do something similar in the OnChange event
 
Last edited:
Here's a simple example of one way to do this...
 

Attachments

It should be possible to output the content of column(2) - the Tamil version - to a textbox.

Further to Colin's suggestion:-


See YouTube at time index 2:50

 

Users who are viewing this thread

Back
Top Bottom