resize datasheet on a form

[Mike]

Hi

I have a datasheet in a sub form and want to be able to resize the subform
to the size of the datasheet, sometimes fields are hidden in the datasheet,
so want to resize whenever fields are hidden/unhidden.

I have looked at the AutoResize in the form properties, but help says: "The
Form window resizes only if opened in Form view. If you open the form first
in Design view or Datasheet view and then change to Form view, the Form
window won't resize."

can anyone help ?

thanks

Mike