Listbox not showing correct column (1 Viewer)

[SandyB]

Hi, I have a listbox on a form that looks up a table to to allow me to pick a stock location. The table only has 2 colums in it, the Primary Key Field (ID) and the Store location. When using this in a a form instead of getting the Stores Location, all I get is the ID. I have tried changing the Bound Volumn Value and the Column Count Fields, however no change. Any Advice would be a great help

Thanks
Sandy

 

[nanscombe]

It could be a column width problem. You could probably try:

Bound Column: 1
Column Count: 2
Column Widths: 0 (assuming you want the first column to be hidden)

 

[SandyB]

Hi Nigel, That was spot on Thanks very much

Sandy