Now() function question

R

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?
 
G

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
 
Top