Alan

I just entered ?MsgBox(Date()) in the Immediate window and pressed enter --
I got 6/14/2005.

Perhaps if you provided a bit more context ... what code do you have this
embedded in?

Have you checked your References to see if any are marked MISSING?

Good luck

Jeff Boyce
Access MVP

"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