Expand and Contract ComboBox on Access Form ~ DataPig

This video demonstrates how to design a combobox to automatically expand when it gets the focus. That is, although the combo has a default width when the form opens, it expands to show all columns when the user enters the combo. Also, when exiting the combo control, it returns to the smaller size conserving some screen real estate and a cleaner look.

NOTE: instead of changing the combo width, you can set the ListWidth property. Here's a video:

Combo Box properties in Microsoft Access (11m25)
   • Combo Box properties in Microsoft Access  

You can also sort a form by a combo column. Here's a video to show you how that works:

Sort Access Form by Combobox Column (19m22)
   • Sort Access Form by Combobox Column  

This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.