title: Access ODBC Subform field size too small to edit
body: <p>I have a form with a combo box that allows a user to filter data in a subform using </p>
  
  <blockquote>
    <p>DoCmd.SearchForRecord , "", acFirst, "[Division] = " &amp; "'" &amp; Screen.ActiveControl &amp; "'"</p>
  </blockquote>
  
  <p>The user should then add data to the subform below. </p>
  
  <p>I've two problems:</p>
  
  <ol>
  <li><p>When the user tries to edit this data, they get "The field is too
  small to accept the amount of data you attempted to add. Try
  inserting or pasting less data". It doesn't matter which of the
  fields the user tries to enter data into, they all suffer this
  problem.</p></li>
  <li><p>The "Division" field that has been filtered, shows up as #Error for
  the new record line. I've set a temp variable for this (see below), so it should
  be showing the value used for the filter, but does so with or without the default set.</p>
  
  <blockquote>
    <p>TempVars.add "Div", [Combo5].Value</p>
  </blockquote></li>
  </ol>
  
  <p>I've looked in my ODBC forms and all the data types/sizes etc look to be the same.</p>
  
  <p>There's data already in this form, which can be edited, even though it's the same size, but no new records can be saved. As well as this I can edit data in the supporting table.</p>