title: Can we format, in VBA, a query field properties after it is create?
body: <p>In Access, when creating a new query using vba, some of the data I'm getting are currency, but it comes by default as <em>General Number</em>. I would like to change it's format like we can do in the <em>Property Sheet</em>, but I can't seem to find a way.</p>
  
  <p>I have tried </p>
  
  <pre><code>db.QueryDefs("TestQuery").Fields("SumOfSomething").Type = DAO.dbCurrency
  </code></pre>
  
  <p>But then I get: <code>Run-time error '3219': Invalid operation.</code> </p>
  
  <p>I have searched around a bit and found a similar question (but couldn't find it back) to which the answer was that you can't change that after it is created. I fail to see the point of having the possibility to change the type if we can't actually do it. </p>
  
  <p>So, in the end, can we change (in VBA) the properties of a field after the query is created?</p>