Microsoft Access - Automatically enter the current date

December 2016




Issue


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

Solution


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 (ccm.net) 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.