List box not showing bound column values

[jallen919]

I have two tables (one linked from another db). I want the second table to lookup the AccountExec from the first table. I have set the AccountExec column as lookup type ListBox, Row Source Type is Table/Query, Row Source is the name of the table (which has two columns). I want one column to show in the list box.

My problem is that no matter what I set the Bound Column property to I only get the first column in my drop down box. Am I missing something simple?

 

[Francescina]

Have a look at the properties window of the list box:

What is the number of columns?
What is the display size (0= invisible!)?

If the format should be correct then execute the query to see the resultset.

 

[Aivars]

Set size of column what don't want to show zero (0) on the "Column Widths" property.
"Column Widths": 0;6.23 or
"Column Widths": 6.23;0

Aivars

 

[Francescina]

If you indicate the number of rows: 2 then the display should be correct!