<div>
I would recommend conditional formatting. &nbsp;Select all of the textboxes at once, then click conditional formatting on the ribbon. &nbsp;<br />
<br />
In the dropdown associated with Condition1, select &quot;Field has Focus&quot;, then set the background color you want the control to have when it gets the focus.
</div>


I would recommend conditional formatting.  Select all of the textboxes at once, then click conditional formatting on the ribbon.  

In the dropdown associated with Condition1, select "Field has Focus", then set the background color you want the control to have when it gets the focus.

1https://filedb.experts-exchange.com/incoming/2012/03_w12/562232/Capture1.gif

Capture1.gif

<div>
<div class="content wysiwyg-content">
Hi. I have an Access 2010 Form, on which there are plenty of controls (textboxes), let's say that their names are TB1, TB2, TB3, ..., TB50. Is there a way to know which one was clicked ?<br />
<br />
I want to change the textbox backcolor to different one, but I don't want to place 50 functions of TB*_click event. Hope I'm clear. Please ask if not.
</div>
</div>


Hi. I have an Access 2010 Form, on which there are plenty of controls (textboxes), let's say that their names are TB1, TB2, TB3, ..., TB50. Is there a way to know which one was clicked ?

I want to change the textbox backcolor to different one, but I don't want to place 50 functions of TB*_click event. Hope I'm clear. Please ask if not.

Access Controls

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.