Subform resize automatically

[joedalton101]

Is there some piece of code that will make subforms resize automatically according to the amount of records displayed?

For example my main form just contains artist names. Subform1 contains albums. Some artists have 2 albums, some have 20. It looks stupid to have a subform resized manually and made huge when it is only filled up with records sometimes, depending on who is selected in the main form.

Thanks

[Stewart Ross]

Hi Joe. As you will have guessed from the lack of response to your question the short answer is no, there is no bit of code to resize a subform automatically in response to dataset size. Typically, subforms are used in datasheet or continuous form mode, where the user simply scrolls multiple records up or down the list. It's all a bit of a compromise between providing good general functionality and coping with specific circumstances that don't fit well with the general limitations.

-Stewart

Is there some piece of code that will make subforms resize automatically according to the amount of records displayed?

For example my main form just contains artist names. Subform1 contains albums. Some artists have 2 albums, some have 20. It looks stupid to have a subform resized manually and made huge when it is only filled up with records sometimes, depending on who is selected in the main form.

Thanks