title: Set Column Width in DataSheet View in Split Form
body: <p>Hi I have an Access Database and a simple Change Record Table.</p>
  
  <p>I also have a Form where I have got all the fields in the top half of the screen and a Datasheet View in the Bottom. See below. 
  <a href="https://i.stack.imgur.com/QgmMl.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QgmMl.jpg" alt="enter image description here"></a></p>
  
  <p>I am trying to set the column widths evenly distributed across the entire width of the screen but so far been unsuccessful. </p>
  
  <p>My code is as follows : </p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="false" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>Private Sub Form_Load()
  
  Dim currentFormWidth As Integer
  
  currentFormWidth = Me.Width
  
  MsgBox ("Current width of my form is : " &amp; currentFormWidth)
  
  Dim standardColumnWidth As Integer
  standardColumnWidth = currentFormWidth / 13 ' Columns of Data to display
  
  Me.Target_Date.ColumnWidth = standardColumnWidth
  Me.Change_Type.ColumnWidth = standardColumnWidth
  Me.FullName.ColumnWidth = standardColumnWidth
  Me.CDSID.ColumnWidth = standardColumnWidth
  Me.Grade.ColumnWidth = standardColumnWidth
  etc...
  
  End Sub</code></pre>
  </div>
  </div>
  </p>
  
  <p>The column widths remain unaltered. I would expect to see columns all fit from let to right within the Datasheet View. 
  I think I am not accessing in the right syntax.
  I think it shold be something like the following : 
  FormName.SubFormName.Target_Date.ColumnWidth = standardColumnWidth ???</p>
  
  <p>Any guidance would be appreciated. Thanks in advance. </p>