List Boxes

[Steve]

Does anyone know how to make a list box expand to fit the criteria? I am
selecting a variable first, and depending on what is selected depends on
whether 1 item or 100 items will display in the list box??

 

[Duane Hookom]

I assume you want the height of the list box control to grow to display all
items in the list box. If so, I think you can use the ListCount like:

Me.List0.Height = Me.List0.ListCount * 215

 

[Steve]

I will try this....THANKS

I assume you want the height of the list box control to grow to display all
items in the list box. If so, I think you can use the ListCount like:

Me.List0.Height = Me.List0.ListCount * 215