I have a simple listbox on a lookup form. I have it's Column Heads property set to yes. The listbox has a query rowsource. I have the fields set up, in the rowsource with
label1:field1
[label 2 nice]:field2
[label 3 nice]:field3
(etc)
I save it, I save the form. I go to form view, and all looks good. i close the form and test things on other forms. I end up back on that form, and the listbox shows the headers as
field1
field2
field3
(etc)
If I go back to design view, back to the rowsource query, the labels are still there. If I save and go back out, they are good again.
Anyone want to help me stop pulling my hair out?
The first thing to check is that there is no other code changing the rowsource of that box to something else. It can be very easy to forget to change all places that set the rowSource or recordSource of a field or form, after you add a field, or change labels.