469,128 Members | 1,445 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,128 developers. It's quick & easy.

Fields formatted as short time shows date on enter

My form is based on a query returning rows of a table. Practically, it
is based on a table, so simple the query is. A field on the form is
formatted as short time. The column in the table, on which this field
is based, is also formatted as short time. When the form opens,
everything is OK, the time field shows time as it should.

When user clicks in this field to edit it, the field all of a sudden
starts showing date 1/01/1900 + time. I do know, that dates are stored
in tables as numbers and what we see in fields is only a matter of
format. The problem is that I don't want users to see the date in this
field at all. Also, they have to highlight all this date and time
expression and overtype it, if they want to edit.

How can I avoid short time format turning into date format on entry
into the field?
Thank you.
Nov 12 '05 #1
0 1828

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Kenny G | last post: by
3 posts views Thread by Matt Brown - identify | last post: by
2 posts views Thread by GerryWiles | last post: by
7 posts views Thread by Ecohouse | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.