[Reopen] possible date time bug?

[asmdev]

hi
one thing that ponder me in ms acess is, why the textbox can't followed the format we set already?

let say i got one bound textbox with the value 16:11 and the format was set to "hh:nn" but access change it to short date automatically.

whenever i put the mouse pointer on the textbox, it turns out to be "4:09:00 PM", so, i wonder why?

[asmdev]

i was force to use something like this in order to achieve what i want

txtTimeDifferent = Format(tOut - tIn, "hh:nn")

and that is troublesome

and the following

Private Sub Form_Current()
    tIn = Format(tIn, "hh:nn")
    tOut = Format(tOut, "hh:nn")
End Sub

[asmdev]

i guess this is solved, but if ur guys got another nice way, feel free to post up

[asmdev]

now, the problem comes, doing so could make ACCESS interpret it as minute:seconds

oh man... this is not solved. reopen again.

[asmdev]

so, let say the user enter 23:22
does it mean 23 minutes 22 seconds?
or
23 hour 22 minutes?

[asmdev]

what should i do to make the following time summation correct?



oviously the answer should be some where more than 18 hours