Putting date into form as default value isn't working

[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

 

[Rick Brandt]

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

DefaultValue is a string. You need quotes around it.

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