"Lost Time" with vb.net date autoformat

  • Thread starter Thread starter Micah Williamson
  • Start date Start date
M

Micah Williamson

Does anyone know how to make it so that a time entered
as a string, and stored in a string record in an access
2000 database can be kept as a string?

When ever I enter a time like 1:00:00 PM into a bound text
box, then I update the access database, the value changes
to a date with time attached. Access then takes the time
portion away, and only leaves the date.

The dataset recognizes the field in the database as text,
but still formats the value into a "DateTime." I have
no "format" conditions set for that value in access 2000.

Anyone know a way around this? Am I missing a property
that turns of autoformat? Do I need to override a method
in an object(I hope not)?
 
When ever I enter a time like 1:00:00 PM into a bound text
box, then I update the access database, the value changes
to a date with time attached. Access then takes the time
portion away, and only leaves the date.

Why don't you store the time as a string in Access?
 
My first choice would be using a time type in access, but
for some reason, visual basic, when ever it saves the time
appends the date to it. I used a string for the sake of
trying to find a way around this. I just want a plain ole
time value, not both.
 
Back
Top