General information
Category:
Forms & Form designer
Joe-
Are you saying the control is bound to a controsource? If so, then you should be able to do something like "SELECT A+B AS C, A FROM [ETC]". Set the combo's row width to "200,0" or whatever, then set the boundcolumn to 2.
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only