Listbox column width idea - feedback

[Homegrownandy]

I have a listbox that will update based on the value selected in a combo box.

All the records are in one table. But depending on what the category I have selected in the combo box is, I want the listbox to display different fields.

I'm thinking this shouldn't be too hard. If I make all the fields available then the ones I don't have can be set to 0 column width via VBA depending on the value selected.

this is just an idea, so any feedback appreciated, also if anyone knows of any links or even knows themselves how I would go about defining column width in VBA I'd appreciate it.

Thanks!

[ranman256]

sounds fine.
set the col widths....
lstBox.ColumnWidths = "1;0.5;0;0;0.5"

[aytee111]

Another method would be to have multiple listboxes, then you could make them visible/invisible: Me!lstbox.Visible=True(False)

[Homegrownandy]

Thanks both! ill have a go at this today. See if I can get it as I want it.