Re: Multi Column Combox - Changing text in combo box
For moment I am doing a working around the issue by using a "|" between items to divide the single column into multiple columns. When I did this I ran into the issue that when the item is selected the whole column is displayed on the text box when I only need first column. I used the 10 bytes for the first column and I able to extract the data by I can not seem to put this value into the combo box text value. I have tried it various events of the combo box, but no luck so far. Below is an example of the the items in the drop down look like.
Bundy | AL
Dylan | Bob
Bean | Mr.
When I select an item for Example Bundy | AL, I want only Bundy to appear on the Combo box text as the select item, not Bundy| AL. The reason that I want this is because I will searching in the database for that field base on the text of that field.
Does anybody know to fix this problem ?