Invisible values (?!)

[Danryan]

I have a confusing problem, my form contains 2 combo boxes, a listbox, and 4 other text boxes. When the user selects a value from each of the combo boxes, a query is run to determine the listboxes contents. The listbox is has 2 columns - one is hidden as it is the key field, the other is the boxnumber. The query is working fine and displays the correct result/s, however the boxnumber/s are not visible inside the listbox (?!). I am able to click on the “invisible” result/s and the form changes as I want it to. I realise this may seem insane, but I hope some of you have experienced this and can understand what I mean.

 

[dcx693]

however the boxnumber/s are not visible inside the listbox (?!)What do you mean? That they initially show up, but when you click on them they disappear?

 

[Danryan]

I've fixed it, it was due to the column widths. There were 2 values and I've altered the column width accordingly.