Scroll bars and Frames

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Jost - 08 Feb 2005 15:27 GMT

I am working on a Word 2003 multi-page Wizard (template). On one of the
pages, I prompt the user to select the number of Login accounts that need to
be created (1 – 20). Based on the number selected I will display 1-20 narrow
frames which will have various textboxes for Login ID, initial password,
group assignments, etc. I am thinking of using a "master frame" that could
scroll down as no more than five of these smaller frames can fit. I see on
the master frame, where I can set a vertical scroll bar. However, I can not
figure out how to size the frame on my current page so that I can add all the
necessary smaller frames, textboxes, etc. What am I missing?

Reply to this Message

Jonathan West - 08 Feb 2005 15:54 GMT

>I am working on a Word 2003 multi-page Wizard (template). On one of the
> pages, I prompt the user to select the number of Login accounts that need
[quoted text clipped - 11 lines]
> the
> necessary smaller frames, textboxes, etc. What am I missing?

You're missing the ScrollHeight property. Set the Height property to the
size the frame take up on the form, and the ScrollHeight property to the
height of the scrollable area within the frame. Once you set ScrollHeight to
be larger than height, a scrollbar will appear on the frame which will allow
you to position extra controls within the frame.

By the way, this sounds like it may become quite a large form. Beware that
there is a hard limit of 411 controls that you can put on a userform before
it errors out on you. Before you work any further on this, I would recommend
that you do a count of *all* the controls (including labels) you plan to put
on the form to make sure you are under the limit.

And no, I *don't* know why there is a limit. I just know that it exists,
because I have banged my head up against it myself.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Reply to this Message

John Jost - 08 Feb 2005 18:29 GMT

Jonathan,
thank you SO much. This worked fine. I knew it SHOULD work, but I didn't
understand what I was missing. Again, thanks for sharing your expertise.

> >I am working on a Word 2003 multi-page Wizard (template). On one of the
> > pages, I prompt the user to select the number of Login accounts that need
[quoted text clipped - 26 lines]
> And no, I *don't* know why there is a limit. I just know that it exists,
> because I have banged my head up against it myself.

Reply to this Message