Quickly arrange a large number of listboxes so you can see all of them

[Anonymous]

Hello everyone.  I was hoping someone may know a quick way to auto arrange a large number of listboxes on a report so that they do not overlap.  Thank you

[#2 · Accepted solution]

Layout > Rearrange sheet objects

[#3]

Or Layout Align > Adjust Left

etc

[Gysbert_Wassenaar]

In the Layout menu you can find the option Rearrange Sheet Objects. That's it afaik. Or you can try writing a macro. Or just use multiboxes instead of listboxes.

[Anonymous]

Thank you

[MK_QSL]

Layout >> Rearrange Sheet Objects

But if you have more List Boxes, compare to the Screen Size, Few will overlap.

You can decrease the length of List Box by CTRL + A and reduce size using mouse.