Resizing Subform

[sampledhigh]

Hi,
I'm trying to resize a continuous subform automatically depending on how many records it is displaying. It needs to resize to fit all of the contents it displays, but no more. I also need to move labels and text boxes down if the subform size gets larger. This needs to be done every time the user cycles through records in the main form.
Thanks in advance.

 

[Meltdown]

Here's something I picked up to get you started, it resizes the sub depending on the number of records.

 

[msandi]

Check my reply at the end of this post:

shrink and expand subform

 

[boblarson]

Check my reply at the end of this post:

shrink and expand subform

msandi:

Well, I don't know about posting to a 4 year old thread but in any case you missed getting the link in there.