Date/time format

[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.

 

[John Vinson]

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.

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