date/time changes with mouse movement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a field type of date/time. A date is entered into by the
user in the form, but when I look in the table it has somehow converted to a
time 12:00AM. When I scroll through the table or move the mouse from side to
side the date reappears briefly and then converts back to 12:00AM again in
random cells. The data itself doesn't seem to be currupt when it reappears.

In the same table I have a text field that collects the staffID but and the
table is storing this information as small boxes and other strange characters.

I would greatly appreciate help on how to fix this.
 
QueenAccess said:
I have a table with a field type of date/time. A date is entered into by the
user in the form, but when I look in the table it has somehow converted to a
time 12:00AM. When I scroll through the table or move the mouse from side to
side the date reappears briefly and then converts back to 12:00AM again in
random cells. The data itself doesn't seem to be currupt when it reappears.

In the same table I have a text field that collects the staffID but and the
table is storing this information as small boxes and other strange characters.
Click to expand...


The 12:00 AM thing is what you get when you do not enter a
time part and you do not specify the format you want used to
display the date. Since you should never display a table's
sheet view to users, this issue is a big don't care.

The text field displaying funny characters probably means
the data was entered using a non standard Font in a form
text box or the data was imported from another application
that does fancy things with the text.
 
Thanks Marshall...

I've added the correct format to the fields and the dates have reappeared
correctly.

However the Font used in the form is the standard MS Sans Serif. The data is
not imported either. Any other suggestions?
 
Not really. The litlle square boxes are what most fonts use
to display control characters such as Tab, new line, Esc,
etc. The other "strange" characters are coming from the
font (which might have been set via the Format menu) that is
used to display the text field.

If you'd provide a form to display the data, you would be
able to specify each text box's properties.
 
You say the data isn't imported; is it possible the users are doing a copy
and paste of data from somewhere else, like a word document or some such?
 
Back
Top