Forum Discussion
Columns Size in List for VBA Access
- Sep 02, 2022
see this demo using Stephen Lebans code (class).
Could you explain in a bit more detail what this "listed object" is?
Are you talking about a form in datasheet view, perhaps? Or something else.
George_Hepworth First of all thank you for your reply. this is an object in a type form or named "list box"
- George_HepworthSep 01, 2022Silver Contributor
Okay, you want to manage both column widths in Datasheet view forms, and column widths in list boxes.
The code Arnel offered would apply to a form, but that form would have to be in datasheet view.
It can't impact the columns in a list box, though.
You can also manage column widths in list boxes, albeit with a lot more coding. You have a couple of choices here. If you must use a list box to display results, then the process is going to be fairly involved. Or, you can implement the form as a datasheet in a subform in the form with the searching textbox.
Here's a link, by the way, to a complete solution for column widths in datasheet view forms along with discussions about it.
This link is to a solution that allows you to adjust widths of columns in a list box.
Stephen Lebans has not been active for years, but his code is still among the best available in some situations like this. If you have any problems using it, please post back.