Time format in Microsoft Access

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.

Howdy, Stranger!

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