Displaying multiple fields combo boxes

[angybab]

I created a combo box with a list of items with two columns. When I select an item, only the first column is displayed


but I want both columns to be displayed. How can I solve this?

I saw a post on google saying I should use &' '& but its not giving me the desired results.

Also how can I expand the size of the combo box to so that the whole text is displayed?

I will appreciate any help

[Welshgasman]

Normally I hide the first column which is always the ID field and the wizard does this as well.
So set the width in the combo properties Format tab. This will then show extra columns as needed. Column count also needs to be correct.

If you actually only want one column displayed, but two columns of data in that column, then you will need to concatenate using the & character.

HTH

[angybab]

ok, let me try that again