title: Hide a column programmatically in MS-Access
body: <p>I want to hide or show a column based on variable data from a users selection. How do you set a column to hidden in MS-Access 2003? </p>
  
  <p>For Example,</p>
  
  <p>After user change event...</p>
  
  <pre><code>For Each ctl In Me.FormNameHere.Form.Controls
      If (TypeName(ctl) = "Textbox") Then
          If InStr(GetTextList(), ctl.Name) &gt; 0 Then
              ctl.hidden = True
          Else
              ctl.hidden = False
          End If
      End If
  Next ctl
  </code></pre>
  
  <ul>
  <li>What is the best approach to this type of challenge? </li>
  <li>Is there a more obvious solution?</li>
  </ul>