insert current date into a form using system clock

  • Thread starter Thread starter Lorie E
  • Start date Start date
L

Lorie E

I would like to have the date automatically inserted into
a form using the computer's system date. Is this
possible? How would I do it? Thanks!
 
In the Control Source property of a text box on your form, simply enter the
following:

=Date() ' for date only

or

=Now() ' for date and time


hth,
 
Keep in mind that the textbox will autofill when the form opens and display the
Date or Date/Time the form opened but when the system clock changes while the
form is open, the value in the textbox will not change.
 
If you also want the date in the form's table then in that field in the form
have the Default Value at Date()
Evi
 
TO carry the original question one step further, I don't want every form to load the date and time every time. Instead, I want the date and time to be calculated once on loading of the database and viewable on a toolbar no matter where I am in the database.
 
Back
Top