Naming a Group of Objects on a Form

[barno_xvi]

Hi. I was just curious to whether or not it is possible to group of say text boxes on a form together and then name them as "Text_Box_Group1" and then in Visual Basic try to make the entire group invisible?

Thanks!

 

[WayneRyan]

Barno,

The best you can do is name them similarly like "TextBox1, TextBox2, ..."

Then you can loop through them:

Dim i As Long
For i = 1 to 40
   Me.Controls("TextBox" & CStr(i)).Visible = False
   Next i

hth,
Wayne

 

[barno_xvi]

Thanks

Okay, yeah that works. Thanks for your help. Do you know of any good tutorial sites for Access? The advanced kind of stuff that is. I can do the basics but want to learn more about the programming part of it all... Thanks for your help on that code by the way!!

Barnz

 

[WayneRyan]

Barnz,

This site is as good as any I've seen. Check out the FAQ and Sample Database
sections ... otherwise just post when you have a topic and the response should
be good.

There are some sites; Peter Lebans, Candice Tripp, and Dev Ashish. Google them
and you should get some very interesting samples. I hope the names are close.

See ya,
Wayne