Tab Control

[Bob Howard]

On a form. is there a way to get a tab control with a vertical scrollbar?
If not, I'll have to use a sub-form (but I'd rather not). Thanks. bob

 

[Bob Howard]

Thanks.

I want to have a small area of the form scroll-able, but not the entire form
(which fits nicely on a single screen ... assuming I can have just this area
of the form scrollable). There are quite a few controls in this area of the
form, and they're only used sometimes (they're generally considered
"optional" ... from the standpoint of how the application is used).

The rest of the form contains no tabbed controls or subforms ... I just
wanted something "special" for this area of the form. It would make it look
much "cleaner" to the user.

So I guess I'm stuck with a subform for this area of the screen...

Thanks again...

bob

 

[Larry Linson]

So I guess I'm stuck with a subform for this area of the screen...

"Stuck" is not a particularly apt term... you will be using a subform for
one of the reasons it exists. You can work with its Format properties to
make it look "less like a typical subform" which may take some of the
"sting" out of "having" to use it.

It has always puzzled me when people say what they want to accomplish, and
then say, "but not using ..." the specific tool or feature that Access
provides to do exactly what they want to do.

Larry Linson
Microsoft Office Access MVP

 

[Bob Howard]

"Stuck" is not a particularly apt term... you will be using a subform for
one of the reasons it exists. You can work with its Format properties to
make it look "less like a typical subform" which may take some of the
"sting" out of "having" to use it.

It has always puzzled me when people say what they want to accomplish, and
then say, "but not using ..." the specific tool or feature that Access
provides to do exactly what they want to do.

Larry Linson
Microsoft Office Access MVP

Well, I guess I was putting it that way because the form (overall) contains
a significant amount of VBA code and it would be nice to be able to keep it
all in one place. I have nothing against subforms per se ... I'm just going
after simplicity.

bob

 

[Larry Linson]

Well, I guess I was putting it that way because
the form (overall) contains a significant amount
of VBA code and it would be nice to be able to
keep it all in one place. I have nothing against
subforms per se ... I'm just going after simplicity.

I rather like having the code in the (logical) place for code for a
particular purpose. Over the years, I wrote a lot of programs where all the
code was in one "lump" and executed (usually) from front to back. In that
environment, when I wanted to look at the code for a particular feature, I
had to search for it.

When event-driven development came about, I knew to look for code in a
particular place... usually starting with the event property that would
cause it to execute. I guess "you pays your money and takes your choice" as
to which one you like best.

Larry Linson
Microsoft Office Access MVP