select a label control indirectly 1

[aldi07]

Hi, the question applies to Ms-Access 2003 and Ms-Access 2007:

To change a label caption in a form, the code would be:
Me.labelname.caption = “MyNewCaption”

But what if the labelname exists in a variable? (say a table field for example):
I cannot go: Me.Mytable![Field].caption = “MyNewCaption”

What would be the right code in that case?

Thank you

 

[SkipVought]

Me.labelname.caption = Me.Mytable![Field]

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[randy700]

Perhaps DLookup ?


Randy

 

[MajP]

Sorry, but you cannot use Bang(!) notation. You need to use dot notation.
Bang:Me!ControlName
Dot:Me.("ControlName")
or Me.(someVariable)
ex.
dim x as string
x = "someLabelName"
me.controls(x).caption = "MyNewCaption

 

[vbajock]

This entire thread is a syntax error.

 

[MajP]

Thanks vbaJock, I wrote that to quick.

Dot: Me.controls("controlName")
or Me.controls(someVariable)

or since the controls collection is the default property of a form, it is not required. You can.
Me("controlName)
me(someVariable)

But not Me.("controlName")

 

[aldi07]

Thank you vbajock and MajP:
me(somevariable) did the job perfectly well.