Resize height of subform object in main form

I have a system where many subforms are used. Often the size of the
subform had to be larger than could be displayed without scrolling.
I set the height of the subform to the typical height appropriate for
the typical screen resolution they were using.

Now some users have decided to use higher screen resolutions, up to
1280/1024. When they maximize the form, that of course works but the
size of the main form control containing the subform is still smaller
than would be possible with the new screen resolution.

I want to resize the height of the control containing the subform.

But I do NOT want to resize the controls in the form itself. I just
want to use more of the screen height and reduce or eliminate the amount
of the subform that is scrolled.

I have seen two utilities for doing auto form resizing. However, they
both resize all controls. I only want to resize one control.

I am learning about twips and twips per pixel at different screen
resolutions.

I know I can get the window height of the form from
me.form.windowheight

I can reset the control containing the sub form using
mysubformcontrolname.height =

I need some help on how to figure out how to resize it.

Anyone have done this before or can point me to a web page with the
calculation (I have looked at many but so far no joy)?

Bob

Re: Resize height of subform object in main form

Bob Alston wrote:

> I have a system where many subforms are used. Often the size of the
> subform had to be larger than could be displayed without scrolling.
> I set the height of the subform to the typical height appropriate for
> the typical screen resolution they were using.
>
> Now some users have decided to use higher screen resolutions, up to
> 1280/1024. When they maximize the form, that of course works but the
> size of the main form control containing the subform is still smaller
> than would be possible with the new screen resolution.
>
> I want to resize the height of the control containing the subform.
>
> But I do NOT want to resize the controls in the form itself. I just
> want to use more of the screen height and reduce or eliminate the amount
> of the subform that is scrolled.
>
> I have seen two utilities for doing auto form resizing. However, they
> both resize all controls. I only want to resize one control.
>
> I am learning about twips and twips per pixel at different screen
> resolutions.
>
> I know I can get the window height of the form from
> me.form.windowheight
>
> I can reset the control containing the sub form using
> mysubformcontrolname.height =
>
> I need some help on how to figure out how to resize it.
>
> Anyone have done this before or can point me to a web page with the
> calculation (I have looked at many but so far no joy)?
>
> Bob

Would this link help?
http://www.mvps.org/access/general/gen0002.htm