From: | lists <lists01(at)dds(dot)uconn(dot)edu> |
---|---|
To: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: time columns: ms-access bound controls |
Date: | 2004-07-16 01:40:24 |
Message-ID: | 40F73208.3040400@dds.uconn.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
thanks for the reply -
Jeff Eckermann wrote:
> --- lists <lists01(at)dds(dot)uconn(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2004-07-16 06:22:38 | Re: ODBC Developers |
Previous Message | Dario V. Fassi | 2004-07-15 19:16:19 | pgODBC and Unicode |