How to evaluate expressions that don't return string or number?(Eval?) 1

[ViAn]

I want to edit the labels of my controls at run-time:

Forms!MyForm!Label2.Caption = "LabelTxt"

works well. But at run time the nr of the Label will change. Therefore I used the Eval function like I would have done in eg Matlab:

tmpString = "Forms!MyForm!Label" & idx & ".Caption = ""LabelTxt"""   ' idx:integer
Eval(tmpString)

Nothing happened. Is there any way to get this "Matlab-Eval-functionality" in Access and VBA?

Yours sincerely,
van

 

[jrbarnett]

Try

Forms("Myform&quot.Form!Label12 = "text"

John

 

[oharab]

You don't need Eval.
Just use the controls object of the form:

Forms!MyForm.controls("Label" & idx ).Caption = "LabelTxt"

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------

 

[ViAn]

Thank you for the suggestion, but my problem is that I do not know if it is Label1, Label3 or Label12 which is to be changed until runtime. (That will be stored in the integer variable "idx&quot.

Therefore I can not "hardcode" the Label Name. I also tried to put your suggestion into the Eval-function ( Eval(Forms(""Myform"&quot.Form!Label" & idx & " = "text&quot ), but that did not give any improvement.

It would be to great help if there were a way to do this, except for writing A LOT of code.

-van

PS: I think you will have to append ".Caption" before the "="-sign in your suggestion.

 

[ViAn]

Simple, but extraordinary helpful.
Thank you, Ben!