Microsoft Access - Automatically enter the current date

December 2016


In one of my tables, I have a DATE field. How to configure Access to automatically enter the current date?


In theTable creation mode, you must enter the expression = Date(), in the Default box on the General tab for AC field.

Related :

This document entitled « Microsoft Access - Automatically enter the current date » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.