Resizing forms and subforms to fit data displayed

[Guest]

I have a form with a subform on it. What I would like is for the subform and
the subform frame on the form to resize to the size of the data displayed.
The subform is in datasheet view and the form is in form view. I have made
various attempts to accomplish this (both with macros and code to resize) but
have not been successful. Just as you can size-to-fit a form, I want to do
it with an on_open or on_load event. Any assistance would greatly
appreciated.

Ron

 

[Arvin Meyer [MVP]]

Have a look at this code from Stephen Lebans:

http://www.lebans.com/autosize_textbox.htm

 

[Guest]

Thanks, I will give it a shot. I did not consider a text box vs. a subform.
There is no reson why it would have to be a subform. I will respond with the
results.

Ron