Re: time columns: ms-access bound controls

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?

In response to

Responses

Browse pgsql-odbc by date

  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