Subform has default view set to Continuous - Cantmake height expand Automatically

I have a subform on a form and its default view is set to 'continuous form'. How do I make the form, and thus its parent form, expand its height automatically to accommodate all applicab开发者_JAVA百科le records.

Thanks in advance to anyone who can help

Noel

That would be unsafe as it could lead to a form larger than the screen. You can set the height to the largest suitable for the screen, or you can use VBA to set the size of the parent form (DoCmd.MoveSize) and the child form. SizeToFit is only available in design view.