Putting date into form as default value isn't working

  • Thread starter Thread starter jokobe
  • Start date Start date
J

jokobe

I'm trying this:

Forms!tblservices!servicedatum.DefaultValue = Date

Access keeps deleting the brackets () and even worse: it is not working.
Within the field servicedatum "#Name?" is shown, also in the property box
for the field the actual date is shown as the default value.

Any helpful hints? And anyhow, thanks in advance..

jokobe
 
I'm trying this:

Forms!tblservices!servicedatum.DefaultValue = Date

Access keeps deleting the brackets () and even worse: it is not working.
Within the field servicedatum "#Name?" is shown, also in the property
box for the field the actual date is shown as the default value.

Any helpful hints? And anyhow, thanks in advance..

jokobe
Click to expand...

DefaultValue is a string. You need quotes around it.

Forms!tblservices!servicedatum.DefaultValue = "Date()"
 
Back
Top