title: Change value of single textbox in a recordset
body: <p>First off I apologize for not knowing a lot about Microsoft Access forms.  I have had very little involvement with them and this is only to support a legacy product that will soon be replaced.</p>
  
  <p>I have a Microsoft Access form that has a detail section such as the image below (shown in <code>Design View</code>).
  <a href="https://i.stack.imgur.com/TzjV7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TzjV7.png" alt="enter image description here"></a></p>
  
  <p>I believe the first 6 textboxes are bound to a data set, the last one is bound to nothing (I added it for what I'm trying to do).  When I view the form in <code>Form View</code> I see many results (which come from the bound table).  The only textbox that does not have info in it is the last one to the right (Unbound).</p>
  
  <p>My goal is to just simply change the value and back color of the following textbox in red.
  <a href="https://i.stack.imgur.com/Xhkhg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Xhkhg.png" alt="enter image description here"></a></p>
  
  <p>I want to edit the contents (change "jk" to "Error") and I want to change the background of that one textbox to RED (vbRed).  The problem is when I try to change the backcolor it changes all the textboxes called "Errors" (that entire column).</p>
  
  <pre><code>ErrorHandler:
  Forms![MyForm1]![Errors].BackColor = vbRed
  </code></pre>
  
  <p>If I want to get the value of the currently selected cell I can just do the following and it works fine...</p>
  
  <pre><code>MsgBox "Debug: " &amp; Forms![MyForm1]![Code] 'The first column
  MsgBox "Debug: " &amp; Forms![MyForm1]![Name] 'The second column
  MsgBox "Debug: " &amp; Forms![MyForm1]![Number] 'The third column
  MsgBox "Debug: " &amp; Forms![MyForm1]![Errors] 'The Unbound (last column)
  </code></pre>