title: ms access - checkbox based on value of textbox
body: <p>I am building a report in access 2007, and trying to set a checkbox to true based on the value of a string in a textbox.
  For example:  If txtBoxValue = "Injury" then chkBoxValue = True(Checked) Else chkBoxValue = False(unchecked).</p>
  
  <p>This is the value I have in the source control of chkBoxValue.</p>
  
  <pre><code>=IIf([txtBoxValue]=”Injury”,1,0)
  </code></pre>
  
  <p>I am new to VBA, and any help would be appreciated.</p>