AutoColumnWidth is a Database containing functions to enable auto sizing of Columns in Form Datasheet view by clicking on the Column Header. Also contains a class to NOT allow the user to change the ColumnWidths at runtime.
Access offers this function but only for the rows of the Datasheet that are currently in view. AutoColumnWidth checks every row of the Datasheet to calculate the final width required to completely display the contents in every row.
Version 2.0 - Added support for Column Freezing for ListBox, Combo and CheckBox controls!
Version 1.8 - Improved implementation thanks to Sandra Daigle!
Version 1.6 - Improved implementation thanks to Elmar Boye!
Version 1.5 - Added method to NOT allow the user to change the Column Widths at runtime
Version 1.0 - First release
Thanks to Dirk Goldar for pointing out that with A2K or higher, the form's SelTop property returns a value that is equal to the current column plus 1. Incorporated a solution on May 1, 2003.