Change column count in listbox (1 Viewer)

[JPR]

Hello friends,
Can anyone help me with this doubt?
I have a form with a combo and a list box. The combo lists the various queries. Depending on the users' selection, the combo propagates it results in the listbox.
My problem is that the listbox is set to 2 columns but some queries will required 3 or 4 columns, so I was wandering if there is a way to set the Column count automatically. Thank you

 

[bob fitz]

The number of columns can be altered with the Column Count" property. You will need to adjust the "Column Widths" property as well.

 

[JPR]

Thank you Bob,
I was hoping there was a way to adjust the number of columns and their with dynamically, basically in an automated way depending on the number of fields of the query selected in the combo.

 

[deletedT]

You can do it in VB
After changing combo row source, you can run a code to change your listbox properties:

mylistbox.ColumnWidths=....

ListBox.ColumnWidths property (Access)

Office VBA reference topic

docs.microsoft.com

mylistbox.columnCount=.....

ListBox.ColumnCount property (Access)

Office VBA reference topic

docs.microsoft.com

 

[JPR]

Thanks