insert current date into a form using system clock

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!
 
C

Cheryl Fischer

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,
 
P

PC Datasheet

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.
 
E

Evi

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
 
S

scottinidaho

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top