Auto Date

K

Kerry

This is a fairly basic question.
I currently have a date box which enables the user to enter the date. Is
there any possibility of the box to automatically display todays date, and
save details with todays date. (ie, so if I saved details under todays date,
and decided to retreive at a later date, the date i saved it under would
appear with all the details)
 
K

Kerry

Yes I have already done this, however it displays __/__/___ on the date box.
I need it to display todays date automatically.... Is there something I am
doing wrong?

Thanks!
 
R

Rick B

If you have put the statement below in the 'default' then it will display
today's date.

What you are describing sounds like you have formatted the field as a date
(which does need to be done) but you have not made an entry in the default
property. Entering =date() in the default will cause the current
date to pop into that field when you hit a new blank record in your form.

Note: This is in a FORM not in the TABLE.


Rick B
 
K

Kerry

Thankyou! Now working...!!

Rick B said:
If you have put the statement below in the 'default' then it will display
today's date.

What you are describing sounds like you have formatted the field as a date
(which does need to be done) but you have not made an entry in the default
property. Entering =date() in the default will cause the current
date to pop into that field when you hit a new blank record in your form.

Note: This is in a FORM not in the TABLE.


Rick B
Click to expand...
 
Top