Sizing subforms

[ruth10uk]

I have a subform set up in datasheet view and want the subform to automatically change height depending on the amount of lines used in the subform. I have set the can shrink and can grow properties to yes but they don't seem to make any difference (is there something else I need to do to make them work?)

Thanks
Ruth

P.S great website!

 

[Rich]

Can shrink/grow applies to the printing of the form only, there is code around to dynamically re-size a continuous form though.

 

[ruth10uk]

resizing suborms

If I change the subform view from datasheet to normal form view what is the code I need to use to resize it?

 

[Autoeng]

If you want a grab handle so that you can resize a particular area FMS Inc. has Total Access Components that includes "Splitter" that may be close to what you are looking for. However, it requires that the user resize the section. I don't know of any code to change the subform area based on what it contains.

Look at www.fmsinc.com. We have discussed resizing your forms for the users screen resolution on here before but I don't think that is what you are looking for.

Autoeng