By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 2,015 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

Resize height of subform object in main form

P: n/a
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
Nov 27 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 27 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.