472,123 Members | 1,334 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,123 software developers and data experts.

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 1951

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.