I have a combobox that has values from two columns displayed. For example "A Active" "C Cancel" "E Expired" and so on. When you select "A Active", an "A" appears in the text box and is stored in the table. I want to be able to select "A Active" and still have "A" stored in the table but I want "Active" to appear in the text box.