Re: time columns: ms-access bound controls

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