current date

  • Thread starter Thread starter Manton
  • Start date Start date
M

Manton

I have a date field (Date Completed).
I created a form with this field in it but i want this date field to show
the current date just in this form.
I have not had any luck with the Date() setting in the property of this
field in the form. It just stays blank waiting for the user to enter a date.
please help.
 
So, let me get this right, you added a text field to the form and set its
format to one of the date types. Then in the default value property you put
"Date()". This should work. Could you verify this for me? If this is not
working, what version of MS Access are you using?
 
I'm using Access 2000.
The date is in tbl_main. It is not set to default Date().
I however want this field found in a particular form to show date().Even
though i click the property of this date field in this form and select under
the Default Value: date() - it still does not give me current date. So its
simply for the sake of this one particular form that I want the date to show
current date.
 
Back
Top