Now() function question

[Randy]

Whenever I use this function it puts the date and time into the field
even though the imput has a short date.

What should I do to get a short date with Now()? Or should it be coded
something else?

 

[Graham R Seach]

Randy,

Whether you use Now() or Date(), Access always includes both the date and
time component, however, the time component is set to 00:00:00 when using
Date(). Try setting the field's/control's Format property = Short Date.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Mike]

Try using Date() instead of Now().