I have a subform that I use in Datasheet view to review and edit records in a table that match user search criteria.  The main form also has a button to allow the user to add and remove columns and change their column orders. I do this by changing the .Visible and .ColumnOrder properties on the controls within the data sheet subform.

My issue is that as I add more columns into the view, they exceed the initial width of the subform and require scrolling around inside the subform on the main form.

I would like to have a way to dynamically adjust the width of the subform (and if needed, the main form too) to fit the visible controls so that the user doesn't need scroll bars to view the columns that don't fit into the static sized subform.  I would also like to set a minimum and maximum width for the forms (mostly for cosmetic purposes).

I was inspired by the Access Developer 37 lesson, but that pertains to adjusting the size of a control and not the forms themselves.