ms access 2000 multiple check boxes inside a group field

we have ms access 2000 form that requires multiple check boxes (10 boxes). Next to the check boxes we put lines to separate the check boxes. Is it possible to put all theses check boxes  and lines inside a group type field so that if we make properties changes like making all the check boxes and lines invisible we just apply the property change to the group field.
ShenAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
There is a "quick and dirty" trick to tag every control that you want to control visibility and use a control iterator to handle them like this :
Dim ctl As Control
For Each ctl In Me.Controls
   if ctl.Tag = "hide" then ctl.visible = false   
Next

Open in new window

PatHartmanCommented:
No.  Access does not support control groups.  However, you can select multiple controls at once and change all their common properties at one time.  When you select different types of controls, only the common properties show in the properties dialog.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
That being said.
You can "Group" all objects of the *exact same* object type.  (for example, ...all the checkboxes))
Then if you select one of them, they will all be selected, ..and then you can modify one property for all of the grouped objects.

To do this, open the form in design view. Select all the exact same objects (for example, ...all the checkboxes)
Then navigate as follows:
Arrange-->Sizing & Ordering-->Size Space-->Grouping-->Group
You can do this for all the lines as well.

So again, (as Pat stated) you cannot really group dis-similar objects into one group, , ...the best you can do is group all the same objects.

Hope this helps

JeffCoachman
PatHartmanCommented:
I don't use the Group "feature" since it resizes controls and so it always seems to be less than helpful.
Jeffrey CoachmanMIS LiasonCommented:
@Pat,
I rarely use it too.
Just because sometimes I will forget, and try move one control, ... and they all move!
;-)

Either that, or I will try to modify the properties of one control, ...and they all change!
;-)
Then I have to remember where to go to "ungroup" them
lol

As a matter of fact, ...just for this Q, I had to actually see if this option was even still available in Acc 3013.

The last time I used this was in Acc 2003.
...and that was just to create an unique new "object" that all I needed to do was build it from multiple lines, and move it around as one object.
;-)

Jeff
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.