time columns: ms-access bound controls - Mailing list pgsql-odbc

From lists
Subject time columns: ms-access bound controls
Date
Msg-id 40F625ED.1080504@dds.uconn.edu
Whole thread Raw
Responses Re: time columns: ms-access bound controls
List pgsql-odbc
hello -


i have an ms-access form with a textbox bound to a "time" column in an
underlying postgresql table.

initially, the field displays correctly:

    16:00

...but when i click in the field to begin editing, the text in the
textbox changes by adding a date component set to the current date:

    7/15/2004 4:00:00 PM

this is would be quite confusing to our users.

is there a work-around for this?  i'm in the process of moving a number
of ms-sql server / ms-access apps to web-based ui's hitting our
postgresql database, but i need to get the access apps working with the
postgresql first...

btw, i'm using  postgresql 7.3.3 on red hat 7.2


thanks


pgsql-odbc by date:

Previous
From: "Mark Dexter"
Date:
Subject: Which Linux ODBC Driver Versionfor 7.4.3?
Next
From: Jeff Eckermann
Date:
Subject: Re: time columns: ms-access bound controls