hello

i have a user form in excel that builds itself (text boxes
visible on/off) based upon the fields within an access
table. However there are 47 text boxes. Is there a way
that i can show only 15 or so, and use the scroll bar to
scroll down for the rest?

TIA

Nath

User Forms, Frames and Multi Pages support scroll bars.
Select this option from the Properties list. To view this
list, first activate the object and right click.

You'll probably want the fmScrollBarsVertical option. You
must also set a ScrollHeight greater than the height of
the container object, whatever is required to allow
veiwing of all text boxes.

Regards,
Greg

hello

i have a user form in excel that builds itself (text
boxes
visible on/off) based upon the fields within an access
table. However there are 47 text boxes. Is there a way
that i can show only 15 or so, and use the scroll bar to
scroll down for the rest?

TIA

Nath
.