Does Group Boxes exist in access ?

[Grooz13]

I wanted to know if Group Box Control exist in access so when I use some VBA code I can modify lot of things at the same time

 

[DCrake]

Don't quite know what you mean by "Group Box"? provide an example of what you want to do, this may help.

 

[vbaInet]

Look for the Option Group control in the Toolbox.

 

[Grooz13]

well In my head and on visual too I think it's something that contains other control
let's say I want to .visible false 10 textbox, well with a group box I could only .visible = false the group box

 

[vbaInet]

There's an ActiveX Frame control you could look into.

 

[boblarson]

well In my head and on visual too I think it's something that contains other control
let's say I want to .visible false 10 textbox, well with a group box I could only .visible = false the group box

It exists in VB6 but not in Access.

 

[Grooz13]

damn
*extra character*

 

[vbaInet]

The ActiveX frame control is the closest you can get to the Group Box but it can be a tricky business. For example, if you want to use it you would need to set an object to the control:

Dim fra as Frame

Set fra = Me.FrameControl

fra.Enabled = False

 

[SOS]

The ActiveX frame control is the closest you can get to the Group Box but it can be a tricky business.

Including the fact that it isn't installed on every machine, so you would have to do so. And, for example, I can't even find it on mine even though I have VB6 installed. It isn't in my ActiveX control list (unless I'm looking for the wrong name).

 

[vbaInet]

Including the fact that it isn't installed on every machine, so you would have to do so. And, for example, I can't even find it on mine even though I have VB6 installed. It isn't in my ActiveX control list (unless I'm looking for the wrong name).

Microsoft Forms 2.0 Frame

 

[DCrake]

You could use the activeX control
Microsoft Forms 2.0 Frame

 

[vbaInet]

You could use the activeX control
Microsoft Forms 2.0 Frame

A tad slow there David

 

[missinglinq]

In Access VBA the simple way would be to use the Tag Property of the textboxes in question. In Design View, select all of the desired textboxes,
go to Properties - Other and in the Tag Property enter Marked. Then to make the boxes disappear:

Dim ctrl As Control

SomeOtherControl.SetFocus

For Each ctrl In Me.Controls
    
       If ctrl.Tag = "Marked" Then
         ctrl.Visible = False
       End If
    End If
 Next

SomeOtherControl can be any control on the form except one of the ones you want to control. The line

SomeOtherControl.SetFocus

is necessary because you cannot set a control's Visible Property to False if it currently has the focus.

If you need to do this a number of times in a form, you could place the code in a sub in the form's code and simply call the sub each time.

Linq ;0)>

 

[DCrake]

If you drop a frame onto the form then click on the control you get hatched borders. Right click on the control and select toolbox. Then you can add different controls to the frame and they are all associated to the frame.

 

[SOS]

Microsoft Forms 2.0 Frame

I'd go with Linq's suggestion over using an ActiveX control. I avoid them like the plague if I can. I don't like using ActiveX controls because I've run into too many problems between machines with them and so unless I absolutely have to (and I did in one case using an Inet control for downloading documents), I won't use them.

 

[vbaInet]

I'd go with Linq's suggestion over using an ActiveX control. I avoid them like the plague if I can.

Ditto!!!

(and I did in one case using an Inet control for downloading documents), I won't use them.

... and I bet you put it in a lot of work to customise it only to find that it didn't work in some enviroments

 

[SOS]

... and I bet you put it in a lot of work to customise it only to find that it didn't work in some enviroments

Well, not really but I did have to set up a VB6 install program so it would install the control I needed to any new workstation that might need to use the program.