Skip site navigation (1) Skip section navigation (2)

Re: time columns: ms-access bound controls

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: lists <lists01(at)dds(dot)uconn(dot)edu>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: time columns: ms-access bound controls
Date: 2004-07-16 14:44:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
--- lists <lists01(at)dds(dot)uconn(dot)edu> wrote:
> 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?

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! 

In response to

pgsql-odbc by date

Next:From: Peter EisentrautDate: 2004-07-16 20:38:21
Subject: Re: odbc bug in convert.c
Previous:From: Thomas ZehbeDate: 2004-07-16 10:50:51
Subject: odbc bug in convert.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group