I already have this. The dropdown of the combobox has 2 columns showing Building Desc and Building #. I need the textbox part of the combobox to show the Building # but it shows the Building Desc instead. Any ideas?

>Set two column widths (e.g., 200,75) in the ColumnWidths property and the box will display both columns.
>
>>I have a combobox with the following settings:
>>
>>RowSourceType=3 - SQL Statement
>>RowSource=SELECT Buildesc, Buil FROM Buil WHERE STR(Buil.Proj,4)=mcproj ORDER BY Buildesc INTO CURSOR cBuilList
>>BoundColumn=2
>>BoundTo=.T.
>>ControlSource=Builinfoview.Buil
>>
>>What I am trying to do is allow the user to access the combobox items based on Buildesc because the users know the names better than the number. But I want the combobox to show the Building number (Buil). Any ideas? TIA