Thread: time columns: ms-access bound controls

hello -


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.

is there a work-around for this?  i'm in the process of moving a number
of ms-sql server / ms-access apps to web-based ui's hitting our
postgresql database, but i need to get the access apps working with the
postgresql first...

btw, i'm using  postgresql 7.3.3 on red hat 7.2


thanks

--- lists <lists01@dds.uconn.edu> wrote:
> hello -
>
>
> 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.

>
> is there a work-around for this?  i'm in the process
> of moving a number
> of ms-sql server / ms-access apps to web-based ui's
> hitting our
> postgresql database, but i need to get the access
> apps working with the
> postgresql first...
>
> btw, i'm using  postgresql 7.3.3 on red hat 7.2
>
>
> thanks
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>




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

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?

--- 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