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
|
Список | 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 по дате отправления: