title: MS access date format
body: <p>I have an ODBC connection to an informix database from a MS Access database and want to show the time in a query as held in the native database i.e. "dd/mm/yy hh:nn:ss.000".  It seems that no matter what format I try in Access I cannot emulate this, although I can do this in MS Excel!?</p>
  
  <p>I've used, amongst others, but to no avail:</p>
  
  <pre><code>Format([startdatetime],"dd/mm/yy hh:nn:ss.000")
  Format([startdatetime],"dd/mm/yy hh:nn:ss,SSS")
  </code></pre>
  
  <p>Any ideas?</p>