Panel Control in Access 2003

[knechod]

I realize that there is no intrinsic panel control in Access 2003, but
I am wondering if using a series of 1-page tab controls might
accomplish the same thing. I would like to split my form up into 4
regions, and manage them as groups, instead of 100's of text boxes,
labels, and options.

Has anybody heard of something similar to this?

Thanks for any thoughts.

Kevin

 

[Tom van Stiphout]

On Sat, 21 Jun 2008 17:08:30 -0700 (PDT), knechod <[email protected]>
wrote:

Yes, you can use a tab control for that. Perhaps you'd want to hide
the tabs themselves at runtime so just the panel shows.
You could also use subforms, and switch them out by setting the
SourceObject property.

"...hundreds of text boxes..": is that a good idea?

-Tom.

 

[knechod]

You caught me. It's not a good idea; it's an exaggeration!

Kevin

 

[Larry Linson]

It's not good to exaggerate, or bend the wording to make some situation look
worse than it is in these newsgroups. When found out, you have done your
credibility no good. Then when you have a real, honest-to-goodness problem
to discuss, you may wonder why you seem to be ignored.

Larry Linson
Microsoft Office Access MVP


You caught me. It's not a good idea; it's an exaggeration!

Kevin

 

[Dirk Goldgar]

I realize that there is no intrinsic panel control in Access 2003, but
I am wondering if using a series of 1-page tab controls might
accomplish the same thing. I would like to split my form up into 4
regions, and manage them as groups, instead of 100's of text boxes,
labels, and options.

Has anybody heard of something similar to this?

It sounds like a reasonable idea, as does the alternate suggestion of
subforms. Another alternative you can use to logically group controls
together for group manipulation is to use each control's Tag property to
identify what group it's in. Then you can change properties for a group by
looping through all the controls and acting on only those controls whose Tag
properties indicate that their in the group you're concerned with.

 

[knechod]

ok, I see three possibilities presented:
1. Go with the single-page tab control
2. Do the same thing with switching subforms
3. Use the Tags property

If I were to do this over, I would probably go with option 3. On
thing I have found is that formatting of tab controls and pages is
lacking. I am not able to control color and placement as well as I
would like. But my biggest worry was additional complexity of
embedded controls. It sounds like it should be okay.

And, in the interest of precision, I have 240 controls on the page.
(Write on the blackboard a million times, "I will not exaggerate. I
will not exaggerate ...") ;-)

Thanks for your input!

Kevin

[snip] (Is this still proper Usenet protocol?)