title: Change the name of a button that is the "ActiveControl" VBA Access
body: <p>I have a button that has a label and the button executes a vba event after it is clicked. I want to change the label and font color on the button after the event finished. What is the best way to accomplish this? I tried using <code>Me!ActiveControl.Name</code> but found that it is Read-only and the name could not be changed using it. I should note that the form executes some sql and returns results. The button that I want to change the label on takes action on each of the records returned from the search/SQL query. I also want to note that the initial label on the button is set by the control source property after the SQL returns results and some of the fields in the results have data.</p>
  
  <p>The relevant code is posted below.</p>
  
  <pre><code>Dim ctlLabelName As Control
  Set ctlLabelName = Screen.ActiveControl
  
  'A Whole bunch of stuff is here'
  
  MsgBox "Hello" &amp; ctlLabelName &amp; "there", vbOKOnly, "Label Name"        
  Me!ReprocessInvoice.Name = "processed"
  </code></pre>