Are you using Date for any other purposes in your application: the name of a
variable, the name of a field in a table, the name of a control on a form or
report, etc.? If so, rename it.

If not, then Jeff's suggestion of the checking the references is the next
thing to do.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Alan Ibbotson" wrote in message
...
I am trying to return the current date.

Using VBA, in an event procedure I have:

MsgBox (Date), I have tried entering Date() but it reverts back to text
shown. When the code is executed I get an error that the "date field" can
not be found.

What's up with that? TIA