not value but text

[schalkse]

Hi guys, maybe this has been asked someowhere before or it's a realu dumb one. But can't find it out.
I have a listbox that brings up a record in a form. It contains brand, type, kind and serial number. It gets it from my table. When i look at the table, brand, type, ...etc are all filled with text like "mercedes", "CLK", etc but in the form when i go through the listbox it only shows the idnumber behind it. So schowing me "2", "5", etc. How can i change this that it shows the same as in my table?

Thanks

 

[Pauldohert]

Look at the column count and column width properties of the lisbox.

 

[Jibbadiah]

If you used the listbox wizard, it should allow you to specify the fields that you want, and it will allow you to choose the width of each column in your list. Otherwise, as Paul suggests, open the properties and look at the column count and column widths sections. For example:
Column count 2
Column widths 1.501cm;4cm

... Keep adjusting the widths until you get it right.