Re: time columns: ms-access bound controls

Поиск
Список
Период
Сортировка
От lists
Тема Re: time columns: ms-access bound controls
Дата
Msg-id 40F73208.3040400@dds.uconn.edu
обсуждение исходный текст
Ответ на Re: time columns: ms-access bound controls  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Ответы Re: time columns: ms-access bound controls  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: "Dario V. Fassi"
Дата:
Сообщение: pgODBC and Unicode
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: ODBC Developers