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???
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???