Date/time format

  • Thread starter Thread starter Shelby
  • Start date Start date
S

Shelby

Can someone tell me how to format a field to allow a user
to enter a date and time in the same field in Access
2000? I've tried using the General Date format, but can't
get both pieces to display.
 
Can someone tell me how to format a field to allow a user
to enter a date and time in the same field in Access
2000? I've tried using the General Date format, but can't
get both pieces to display.
Click to expand...

Use a Format property of "Long Date" or roll your own using both date
and time format characters; for instance

ddd, dd mmm yyyy hh:nn:ss

will display

Fri, 26 Sep 2003 13:50:13
 
Back
Top