default value+now() in table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ms. M.Thipparat - 19 Apr 2005 07:55 GMT

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.

Reply to this Message

Allen Browne - 19 Apr 2005 12:51 GMT

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()

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

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

Reply to this Message