Now() function question

  • Thread starter Thread starter Randy
  • Start date Start date
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?
 
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
 
Back
Top