title: Access 2013 VBA Editor Changes Date() to date
body: <p>When I type <code>strDate = Date()</code> it switches to <code>strDate = date</code>, and then the code does not run correctly because it does not know what "date" refers to.  This is in a brand new Access 2013 database with only a single form with a button to run the code and a table with only one field to insert the date.</p>
  
  <p>References that are checked for this database are:</p>
  
  <ul>
  <li>Visual Basic For Applications</li>
  <li>Microsoft Access 15.0 Object Library</li>
  <li>OLE Automation</li>
  <li><p>Microsoft Office 15.0 Access database engine Object Library</p>
  
  <pre><code>Dim strDate As String
  strDate = Date()
  
  DoCmd.SetWarnings False
  
  Dim strSQL As String
  strSQL = "INSERT INTO Table1 VALUES ('" &amp; strDate &amp; "');"
  DoCmd.RunSQL strSQL
  
  DoCmd.SetWarnings True
  </code></pre></li>
  </ul>