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

From Jeff Eckermann
Subject Re: time columns: ms-access bound controls
Date
Msg-id 20040716144420.26765.qmail@web20813.mail.yahoo.com
Whole thread Raw
In response to Re: time columns: ms-access bound controls  (lists <lists01@dds.uconn.edu>)
List pgsql-odbc
--- lists <lists01@dds.uconn.edu> wrote:
> 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?

Hmm, looking closer, I see your problem.  This is not
something that I have had to deal with before.  The
problem appears to relate to the fact that Access has
only one data representation for both date and time,
with the display determining how the data is
represented to the user; whereas SQL has separate date
and time types.  Odd that the problem should only be
evident on mouse click; when I tab to the control, the
format is not changed!

My brief research has not found any answer.  I am
thinking that this is really an Access issue.  Perhaps
you may do better on the
microsoft.public.access.odbcclientsvr newsgroup.
>
>
>




__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: ODBC Developers
Next
From: Michał Wójcik
Date:
Subject: Bug "Access violation at address XXXXX in module 'psqlodbc.dll'"