title: VBA - Loop through Controls on a form and read the value
body: <p>I would like to loop through controls on a form and read the value. However the Value and Checked properties are not available. My question is, how can I read the value of a control (in this case a checkbox) when I loop through them?</p>
  
  <pre><code>Dim Ctrl as Control
  
  For Each Ctrl In frmMaintenance.Controls
  
      If Left(Ctrl.Name, 7) = "chkType" And **Ctrl.Value = True** Then            
  
      End if
  
  Next Ctrl
  </code></pre>