set focus to textbox using variable name 1

[johnnyv]

Hi

How do I set focus to a text box when the name of the textbox is stored in a variable?

Thanks

 

[cLFlaVA]

Try this:

Dim tbName as String

tbName = "SomeTextBoxName"
Evaluate(tbName).Activate

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?

 

[Hypetia]

Here it goes.
___
[tt]
Dim strVarName
strVarName = "Text2"
CallByName(Me, strVarName, VbGet).SetFocus[/tt]

 

[CasperTFG]

Hmmm The one way I can think of is...

Dim ctlControl As Control
For Each ctlControl In Form1
If TypeName(ctlControl) = "TextBox" And _
ctlControl.Name = sMyTextBoxName Then
ctlControl.SetFocus
Exit For
End If
End If
Next


Casper

There is room for all of gods creatures, "Right Beside the Mashed Potatoes".

 

[CasperTFG]

Wow 3 very different answers... I like clFlava's

Casper

There is room for all of gods creatures, "Right Beside the Mashed Potatoes".

 

[johnwm]

Unfortunately Evaluate isn't a VB6 function....

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[cLFlaVA]

Whoops! Apologies.

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?

 

[johnnyv]

Thanks guys

 

[ESquared]

I was going to mention the following but then found "EbExecuteLine just does not work properly in compiled programs."


Execute line of code from string variable or text box! This works !!! faq222-492

http://www.tek-tips.com/viewthread.cfm?spid=711&newpid=711&sqid=97332

 

[strongm]

Yep, the FAQ is misguided (and merely a god example of someone copying something they read on the internet and assuming it was correct). EbExecuteLine is very, very unreliable in compiled programs. However, we've discussued this issue on numerous occassions in this forum, and provided examples of relatively simple alternatives.

And for this specific case it is really, really simple...

Controls(StringContainingControlName).SetFocus

 

[ESquared]

Ha! Duh.

I've even done that in my own code.