Problem using "Date()" function

[ets960]

I have a text box inside a subform that I am trying to make it say the current date. I have been also having this same problem at various locations in my program, the users get a compile error, but mine just doesn't work right. Here's what happens:

I type in default value of a text box "=Date()" and it says "The Function you entered can't be used in this expression". I try doing it in the table itself, it gives the same error.

This is using Office 97, the text box is set to a short date value...

When I type in =Now(), it works, but I would prefer to have the date. Any ideas???

 

[pbaldy]

Do you have a field in the table named "Date"?

 

[ets960]

That was my first thought on this, I doublechecked all my forms and tables and nothing that I can find that is named "Date"

 

[boblarson]

Are you sure you are putting =Date() with no quotes around it? Also, what is the name of the text box that you are trying to use this with?