Hey Joe,
>I tried Select A + B, A (A is the value, B is the description) with BoundColumn = 2, BoundTo = .T. but no luck. The display in the combo box is still blank. It seems the display is somehow hard-wired to pick up the first column in the SQL result, and if the first column is larger that the ControlSource, then it won't show anything at all. The effect of setting BoundColumn = 2 is to change the combobox.Value to whatever is in column 2. The display itself has a mind of its own.
This doesn't sound right. Maybe you could send me your form (or combo class if thats what your using) and table and I could look at it if your not happy with the final results?
mgh@arss.com