Default date

[Guest]

I having trouble setting the default value on my forms to
todays date. If I enter Date() into the default value box
then Access fails to recognise it. It only appears to
work if I type in Now(), but even in the short date format
it shows the time as well as the date.

Can anyone help?

Adam

 

[Rick B]

Where are you doidng thsi? What is the field? How is that field defined in
your table? Do you have any input mask or Format set on the form?

"Short Date" format should not show the time.

Rick B


I having trouble setting the default value on my forms to
todays date. If I enter Date() into the default value box
then Access fails to recognise it. It only appears to
work if I type in Now(), but even in the short date format
it shows the time as well as the date.

Can anyone help?

Adam