Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo box doesn't keep the display value selected
Message
From
04/08/1999 17:25:20
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00249881
Message ID:
00249968
Views:
26
>I found what was causing the problem. My SQL statement was Select A + B as C, so that the combobox will show the value A and the description B. However, the resulting C is larger than the control source which is only wide enough for A. This was causing the display value for the combobox to be empty. It works OK if my SQL statement is Select A by itself.
>
>So now I have a working combobox which does display A after choosing a value from the drop-down.
>
>But I need to show the description B for each A. My problem now is how do I show both A and B in the drop-down list and still keep only A in the controlsource?
>
>Thanks for all your input. If you have any inkling of how to do this, please send it.

Try setting the ColumnCount property to 2 and have your SQL return A,B as separate fields.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform