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

From lists
Subject Re: time columns: ms-access bound controls
Date
Msg-id 40F73208.3040400@dds.uconn.edu
Whole thread Raw
In response to Re: time columns: ms-access bound controls  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Responses Re: time columns: ms-access bound controls
List pgsql-odbc
thanks for the reply -

Jeff Eckermann wrote:
> --- lists <lists01@dds.uconn.edu> wrote:
>>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.
>
>
> This is a display problem, not a data problem.  You
> need to set the display format, either in the control
> properties, or in the table properties.  Probably
> easiest to set the format at the table level (open in
> design view, highlight that field, set the "format"
> value to your preference.

i'd already tried setting format and input mask both on the column and
on the control...

any other suggestions?



pgsql-odbc by date:

Previous
From: "Dario V. Fassi"
Date:
Subject: pgODBC and Unicode
Next
From: Peter Eisentraut
Date:
Subject: Re: ODBC Developers