sql server 2000 datetime datatype

  • Thread starter Thread starter Jesse Aufiero
  • Start date Start date
J

Jesse Aufiero

I've bound my access 2003 form to a linked sql server 2000 table. I'm
trying to give my users the ability to edit both the date and time portion
of a datetime column, but I'm having trouble. Ideally I'd like the user to
be able to use two separate textboxes on the form, one for the date portion
of the column, the other for the time portion. The first textbox would
display the date portion and allow edit of the date. The second textbox
would display the time portion and allow edit of the time. Is this
possible?

The problem is that while access will display the time portion, even if I
use a longTime input mask, the value displayed in the textbox switches to
the date portion the second the textbox gets focus. ????

Ideas welcome. Thanks!
 
Jesse

One approach to handle this would be to use two unbound text boxes. You
would have to write all the code that would take the components and combine
them in a true date/time value, and parse the existing date/time values into
their individual components (see DateValue() and TimeValue() functions).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top