Microsoft Access - AutoResize Combo box and List box Columns

Demonstrating how you can implement some basic VBA code utilizing, the undocumented, but powerful WizHook class to automatically resize your combo boxes and list boxes column widths to properly display the content, minimizing wasted space and improving your overall user experience.
Go from wasted white space and truncated content to maximizing what is displayed and allowing your users to see the full content. This also helps future-proof your applications for whatever new entries your users create. Win-win-win.
Article(s) on this Subject:
• www.devhut.net...
My Links:
• www.cardaconsu... (business)
• www.devhut.net/ (blog)

[@xavierbatlle1828]

Very interesting video. I've been using this approach in continuous forms. 😉

[@DanielPineault]

Interesting. I've done something similar in datasheets, yet never thought of doing so in continuous forms. Thank you for sharing.

[@599CD]

Pretty nifty. Thanks for sharing. :)

[@DanielPineault]

Any time Richard. We're all in this mess together! 😉
All kidding aside, it's fun to teach and return some of what others have taught me over the years!

[@599CD]

@@DanielPineault indeed! I feel the same way.

[@hassanrozh6579]

Great job, it's fantastic, thanks so much.

[@DanielPineault]

Glad you like it!

[@rtatt1]

Hi, I remember having to do something similar in my VB3 days 30 years ago!
But am I missing something here? You first check for the longest string and then convert that to a width? But the string of "iii" is longer than "WW" in number of characters but shorter in length. So don't you need to check the real width of each entry rather than the real width of the one with the.... Oh bloody hell, you've just preempted my question at about @18:20. I wish I'd watched it all through now before sticking my nose in!😂

[@DanielPineault]

Lol.
You're 100% right. It's a calculated risk and depends on the font used. The article provides both code samples.

[@behroozyazdani6023]

hi, great job. I read your website but can't find method for putting image from blob field into image control without temp file. Can you help with this?

[@DanielPineault]

I could be wrong, but can you not directly pass the blob to the control
Me.YourImageControl.PictureData = Me.BlobImage

[@SAMYTAHER]

Very Good

[@DanielPineault]

Thank you!