UserForm too big for window

[Angie M.]

Hi,

I have a good sized userform that can display properly with a normal screen
resolution. I have some users that have their resolution set LOW to the
point that the userform is so large for them and it gets cut off at the
bottom. Their tab key works to proceed through the fields on the form, but
they can't see the bottom of the form. I added the scroll bar property -
both set to true and added "5" to the other scroll bar settings, but since
the form fields themselves fit on the form, the scroll bars have no effect on
the userform on the user's screen. It's like there's a disconnect between
the userform and the Word window.

Can anybody help? Thanks!

 

[Karl E. Peterson]

Angie M. laid this down on his screen :

I have a good sized userform that can display properly with a normal screen
resolution. I have some users that have their resolution set LOW to the
point that the userform is so large for them and it gets cut off at the
bottom. Their tab key works to proceed through the fields on the form, but
they can't see the bottom of the form. I added the scroll bar property -
both set to true and added "5" to the other scroll bar settings, but since
the form fields themselves fit on the form, the scroll bars have no effect on
the userform on the user's screen. It's like there's a disconnect between
the userform and the Word window.

Can anybody help? Thanks!

Sounds like you need to resize the form appropriately when it loads.

 

[Fumei2 via OfficeKB.com]

There IS a disconnect between the userform and the Word window. Or, more
correctly, there is no connection in the first place.

A userform is displayed according to its own properties of .Height and .Width
(as well as .Top and .Left). If those dimensions can not fit on-screen
because of the screen resolution...then they can not fit. As you have found
out.

There are two possible things to do.

1. Redesign the userform so it can be fitted into a smaller footprint. I am
willing to bet that this could be done. Using a MultiPage can be a major
route for getting all the controls onto a userform in a smaller footprint.

2. Make TWO userforms. One your "normal" one, and one that has its controls
use a smaller size and/or font. Test the current screen resolution of the
system calling the userform. Call the appropriate userform.

 

[Angie M.]

THANK YOU!!

There IS a disconnect between the userform and the Word window. Or, more
correctly, there is no connection in the first place.

A userform is displayed according to its own properties of .Height and .Width
(as well as .Top and .Left). If those dimensions can not fit on-screen
because of the screen resolution...then they can not fit. As you have found
out.

There are two possible things to do.

1. Redesign the userform so it can be fitted into a smaller footprint. I am
willing to bet that this could be done. Using a MultiPage can be a major
route for getting all the controls onto a userform in a smaller footprint.

2. Make TWO userforms. One your "normal" one, and one that has its controls
use a smaller size and/or font. Test the current screen resolution of the
system calling the userform. Call the appropriate userform.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-programming/201002/1

.