Shrink and grow list box 1

[burgerman]

Is there a way to shrink and grow a list box automatically on form open to only fit the number of records that will be represented in the box?

 

[SgtJarrow]

Although I can think of one way to do this, are you absolutely sure this is what you want to do??? Sounds to me like you may be interested in a combo box instead.

A combo box uses up only one line of real estate....a list box takes up more. A list box includes a scroll bar to see everything in it.

That being said, you are probably leading yourself to disaster with the idea of dynamically changing the list box......today you can for sure say that the box will be between 1 and 6 lines....but tomorrow that value may change from 1 to 1000....and you DO NOT even want to try to work a list box that is 1000 lines long in ral estate.

So think about what you are wanting to accomplish....adn if you really still want to do this....let me know and I will help you out. If we knew what it was we were doing, it would not be called research, would it? - Albert Einstein

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com