How to get the textbox name of the any textbox that is clicked

[adamk1906]

Hello,

I have 480 textboxes in my form. What I am looking to do, is that any time any of thest textboxes are clicked (or double clicked) I want to then get the name of that textbox saved into a variable.

So I have created a public variable called tbName.

What I need is this:

- if the active control is a textbox then
- tbname = active control name.



It is important that I dont just take the active control name all the time as I want all controls other than textboxes to be igored. Secondly, under what event would I even put the code? Would it be the form Click event?

Appreciate any feedback.

Thanks
Adam

[rzw0wr]

Put the code under the click or double click event for all 480 text boxes.

YourVariable Name = YourTextBoxName

If you enlighten us as to what you want to do, I would think we could help you make it somewhat easier than using 480 variables and text boxes.


Dale

[amrut]

You have to decide which event you want to put the code depending on your requirements.
In the form's module, put a function like

Function GetTextBoxName()
GetTextBoxName=Screen.ActiveControl.Name
Debug.Print GetTextBoxName
End Function

In design view, select all the text boxes.For ex. If you choose On Got Focus, then in the On Got Focus event
put =GetTextBoxName()
Hope above helps.

[orange]

Depending on how critical this is to you, you may want to have a look at
http://www.access-programmers.co.uk/...d.php?t=228040

There is a database by ChrisO that has code to do what you are asking.