Microsoft Access - AutoResize Combo box and List box Columns

Рет қаралды 437

D Pineault - Tech, Programming and more

3 ай бұрын

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/autoresize-lis...
My Links:
• www.cardaconsultants.com/ (business)
• www.devhut.net/ (blog)

Пікірлер: 13

@599CD 3 ай бұрын

Pretty nifty. Thanks for sharing. :)

@DanielPineault 3 ай бұрын

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 3 ай бұрын

@@DanielPineault indeed! I feel the same way.

@xavierbatlle1828 3 ай бұрын

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

@DanielPineault 3 ай бұрын

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

@hassanrozh6579 3 ай бұрын

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

@DanielPineault 3 ай бұрын

Glad you like it!

@SAMYTAHER 3 ай бұрын

Very Good

@DanielPineault 3 ай бұрын

Thank you!

@behroozyazdani6023 3 ай бұрын

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 3 ай бұрын

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

@rtatt1 3 ай бұрын

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 3 ай бұрын

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