title: MS-Access VBA Date() works on one PC but not others
body: <p>I am designing my first database from the ground up and I have learned a lot in the last few weeks. One thing that has been eating at me though is that on my login page I have a simple unbound text box with its control source as <code>=Date()</code>. </p>
  
  <p>This works perfectly well on the computer I use most days, but any other computer in the facility I am working out of displays <code>#NAME?</code> instead of the date. </p>
  
  <p>I have tried changing to <code>=Now()</code> and it works fine on all computers. Apparently only <code>=Date()</code> has issues. If the fields control source is changed back to <code>=Date()</code> I am informed that <em>The function you entered can't be used in this expression</em>.</p>
  
  <p>I have checked the MS-Access versions and tried on a machines with and without access. </p>
  
  <p>I really need <code>Date()</code> to work because it is used elsewhere in more vital areas of my code and I may not be able to use <code>Now()</code> in its place. Any ideas as to why this may not work on any PC besides my own?</p>