Show column1 in listbox

[Kay]

Hi

In my listbox I have used a table as the control source. In the street
field I want it to display the street name but instead it displays the
postcode. I think by default it displays column(0) which is te postcode
but I want it to display column(1) which is the street name.

Any help will be much appreciated

 

[drahme]

Hi,
Go to your listbox format properties. Check that column count = 2.
Under Column Widths type in 0;2 and adjust as necessary. 0 means hide
the first column. 2 means set the second column to 2".

Hope that helps.