I have a datasheet subform with enough columns that require a horizontal scroll bar. Each time the filter is changed to show a different set of data, I would like to autofit the columns so that the optimum amount of data is displayed.

Is this possible?

I can change the widths to a preset amount, and I can see the "best fit" option in the Format>Colunm Width menu (although this is not visible in my application), but cannot work out how to autofit from code!

Please help!