Do you have a field or control named Date in the form? You are confusing
ACCESS because it doesn't know that you want the function. Change the name
of the field and control.
Do not use Date as the name of a table's or query's field. It and many other
words are reserved words in ACCESS, and can create serious confusion for
ACCESS and Jet. See these Knowledge Base articles for more information:
List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266
Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/?id=826763
--
Ken Snell
<MS ACCESS MVP>
Troy W. said:
I am trying to set the date control on a form to the current date. The
code
I am using is:
Me![OrderDate] = Date
but date always returns Null. It works fine if I try using Now instead
though. Any ideas?
Troy W.