424,045 Members | 1,250 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,045 IT Pros & Developers. It's quick & easy.

Todays Date

P: 1
In Access 2010 can I make a field populate the current date each time the database is opened?

Thanks in advance for any help given.
Nov 1 '18 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 2.5K+
P: 2,780
Set the ControlSource to

Expand|Select|Wrap|Line Numbers
  1. =Date()
Hope this hepps!
Nov 1 '18 #2

Expert Mod 15k+
P: 31,164
Just to be clear Ivan, I suspect you're actually asking about a Control on a Form or Report. Fields are another matter and your question would have to specify what you're after more clearly for more accurate and practical help.

If it's simply to show then that works fine - in a Query for instance. If you're looking for an existing field to be updated to reflect the day it was opened last then you need to explain what you want more clearly. Very short questions such as this very rarely give enough information to make proper sense. Some more effort is usually required and expected.
Nov 1 '18 #3

Post your reply

Sign in to post your reply or Sign up for a free account.