VBA Code Basics

[Angus]

I have a form which contains three text box controls (text1, text2 & text3).
Those three text boxes are all set to Visible = False. Now, I would like to
write code to make them all visible at a time through looping. Below is the
code

For x = 1 to 3
Me!["text" & x].visible = True
Next x

The above coding doesn't work, as the Access can't read the name of the
control. How can I fix it?

Thank you very much.

Angus

 

[Albert D. Kallal]

Try:

For x = 1 to 3
Me!("text" & x).visible = True
Next x

 

[Van T. Dinh]

Try:

Me.Controls("text" & x).Visible = True

 

[Angus]

It works. Thank you very much!

Try:


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.attcanada.net/~kallal.msn

 

[Angus]

It works. Thank you so much.

Try:

Me.Controls("text" & x).Visible = True

--
HTH
Van T. Dinh
MVP (Access)

I have a form which contains three text box controls (text1, text2 & text3).
Those three text boxes are all set to Visible = False. Now, I would like to
write code to make them all visible at a time through looping. Below is the
code

For x = 1 to 3
Me!["text" & x].visible = True
Next x

The above coding doesn't work, as the Access can't read the name of the
control. How can I fix it?

Thank you very much.

Angus