Howdy, Stranger!

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


Time format in Microsoft Access

kdgab25kdgab25 Member Posts: 4
Hello. I have an access database linked to my 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 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 Thanks in advance for any help!
Sign In or Register to comment.