read index value of a control

[Guest]

How do you read an index value of a control knowing the control's name?

Thanks


Pete

 

[Alex Dybenko]

Hmm, what index you mean? tab index or something else?

 

[Guest]

Alex,
I mean the index given to each control on a form, for example:

Me.Controls(5)

where the index 5 might be the index value of a text box "txtInput".

From the index, I can find the name of a control (Me.Controls(0).Name) but
how do I do it the other way round?

Many thanks

 

[David C. Holley]

Try Me.Controls("controlName").index

Alex,
I mean the index given to each control on a form, for example:

Me.Controls(5)

where the index 5 might be the index value of a text box "txtInput".

From the index, I can find the name of a control (Me.Controls(0).Name) but
how do I do it the other way round?

Many thanks

:

 

[Bas Cost Budde]

Interesting! Why?

The plain search technique comes to mind (air code):

function getControlIndex(cName as string)as long
dim i as long
for i=0 to controls.count
if controls(i).name=cname then
getcontrolindex=i
exit for
endif
next
end function