Full Version: Default Today's Date?
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
gkmros
I am sure this is a fairly easy question for most of you, but I have searched through the posts here on UA and I cannot seem to get a clear answer.

I have a data entry form that contains a date field for inputting the date the entry was made. I have a pop-up calendar which is activated on the double click event and the date can be selected from there. However, about 90% of the time the entry date will be today's date.

Is there anyway that I can have today's date automatically stamp itself into this control when starting a new record entry?

Thanks!
Snapper316
=Now() is todays date with the current system time

=Date() is today's date

and set those under Default value either on table design or on the form
gkmros
Thanks! That worked fine.

I knew someone would have the answer.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.