Time clock Problem using Access

[bermyl33]

Resolved:Time clock Problem using Access

I am using an Access Database and populating a Datagrid. I have 6 time fields in the database. They use the medium time date/time format in the database. They are input via a datetimepicker and are displayed in the database fine. But when displayed in the grid, they show up with only dates and no time! The date that appears is 12/30/1899? Help!

 

[jmcilhinney]

Date/time fields contain a date and a time. The format you have selected in the database displays only the time, but the date portion is still there. When you display the data in the DataGrid it knows nothing of the database so it chooses its own format. You will need to specify the format in which you want to display the date/time columns. Check out section 5.44 on this page.

 

[bermyl33]

Thank you very much, you put me on the right track!