default value+now() in table

G

Guest

I can't set default value now() in Ms. Access table. It's always alert "
compile error in table-level validation expression"

How should I do to solve this problem.

Thank you in advance.
 
A

Allen Browne

Try setting the Default Value of the date/time field in your table to:
=Now()

If you just want the date, without the time of day as well, use:
=Date()

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Field Default Value 0
Trouble debugging: unknown function name in table-level validationexpression 2
Problem using Date() for default value in my Date/Time field 4
Default Value =now() in table 2
I keep getting an "Unknown function "CurrentUser()" error 4
Date() returns "Unknown Function" error 2
Requiring one field contingent on data in another field 0
No duplicates wanted in column except for default value... 1

Top