468,103 Members | 1,225 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,103 developers. It's quick & easy.

"Lost Time" with vb.net date autoformat

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)?
Nov 20 '05 #1
2 2890
"Micah Williamson" <ih*@nbnet.nb.ca> wrote in news:0ff401c377e7$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********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 20 '05 #2
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.ca> wrote in news:0ff401c377e7$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********@rogers.com)
Please delete "REMOVE" from the e-mail address when

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

Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Tony | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.