default value+now() in table

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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]...
 
Back
Top