Using expressions between brackets [ ]

[eleteroboltz]

Hey guys, I'm having some problem here when i try to use a formula between brackets [].
What I'm trying to do is very simple. The better way to explain is with an example:

I just want to write this line:

Me.[cv100].Caption = 33

in this way:

k=100
Me.[("cv" & k)].Caption = 33

Thank you

 

[MajP]

Me.("cv" & k).Caption = 33
which is shorthand for
me.controls("cv"& K).caption

 

[eleteroboltz]

Thank you very much.
The code worked perfectly.

 

[MajP]

One thing. If you use proper naming conventions:
no spaces
and no reserved words
you never have to use brackets (except in sql).

If you name your control "myControl" not "my control" you can simply
me.myControl or me!myControl

Also you can always use dot notation
me.("my control")
only need the brackets for
me![my control]
or a reserved word like
me!