"Lost Time" with vb.net date autoformat

[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)?

[Lucas Tam]

"Micah Williamson" <ih*@nbnet.nb.c a> wrote in news:0ff401c377 e7$e16b9260
$a*******@phx.g bl:

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?

--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Micah Williamson]

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.

-----Original Message-----
"Micah Williamson" <ih*@nbnet.nb.c a> wrote in news:0ff401c377 e7$e16b9260$a*******@phx. gbl:

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?

--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when

replying.http://members.ebay.com/aboutme/coolspot18/
.