Time format in Microsoft Access - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Time format in Microsoft Access

kdgab25kdgab25 Posts: 4Member
Hello. I have an access database linked to my vb.net program. When I update a record from my dataset back to the database, a "StartTime" field is being saved with full the format "DDD MMM DD, YYYY HH:MM tt", instead of a time "HH:MM tt" only. I have this datacolumn binded to a textbox within my program. The datatype for the datacolumn for my dataset is "DateTime", I believe this to be the culprit but there are no other options for "Time" or "Medium Time". The format for the field in access is set to "Medium Time", but vb.net seems to want to write the entire date and time to the database. Any suggestions, pulling my hair out as this is one of many problems I've encountered while using vb.net. Thanks in advance for any help!
Sign In or Register to comment.