Combo box

[Brogrim]

I have 3 fields on the combo box, I want to display the last 2 columns but it is only showing the 2nd column.

Thanks in advance

 

[lupins46]

You can only display one column in a combo.
If you want to display two colums joined togeteher than you need to modify the underlying query to join them as a single column (myfield1 & " " myfield2)

 

[ZmrAbdulla]

You can display all columns in the dropdown list.
Look for "column width" property, set it to desired.

________________________________________________________
Zameer Abdulla
Help to find Missing people
My father was a realistic father; not a vending machine dispense everything I demanded for!!

 

[Brogrim]

When I make the selection it only shows one column. I will try joining the strings

 

[ptpaton]

Whoa...hang on Brogrim. ZmrAbdulla is correct, you can have as many columns in the combo box visible as you'd like, once you drop down on it. Make sure you have 2 or 3 in the number of columns, the column widths are appropriately wide enough, and the size of list is big enough to accomodate the columns. If you want to show only the last two columns, in the query builder of the record source, move the first column to the end and enter "2" in the number of columns. Also, pay attention to the bound column property of the combo box, as it will affect what value you're writing to the record.

If this doesn't work, there's something else wrong. Give us more detail.

-Patrick

Nine times out of ten, the simplest solution is the best one.

 

[Brogrim]

When I click on the combo box it shows the 2 columns but when I make the selction only 1 coulumn is displayed in the combo box, when the combo box has lost focus I wnat it to display 2 columns

 

[ptpaton]

Ahhhh. I see, then lupin is correct. If you want to see the other field, add another text box bound to that field? Otherwise you have to combine the fields in the builder as lupin suggested.

-Patrick

Nine times out of ten, the simplest solution is the best one.

 

[ZmrAbdulla]

May be you can add another column in the reowsource as combine of the columns then set it's width 0 also that bound column. This is not tested .. but just an idea.

________________________________________________________
Zameer Abdulla
Help to find Missing people
My father was a realistic father; not a vending machine dispense everything I demanded for!!

 

[Brogrim]

Thanks for teh help, I am happy with the results.