I have an issue with time display

[William Jones]

Aloha everyone,
I have created a help desk database for work, but I have an issue
with one of the date fields on the forms for the database. i took
several screenshots, which can be accessed at:

http://home.hawaii.rr.com/whjones2/Images/access

In short, the date should be displayed as short date with this format
00:00;;_, however only one of the two dates displays properly. the
other one displays medium date, which also displays seconds, and on
some forms, AM or PM. I want both of the date fields to display the
date the same way. If anyone has any suggestions, and/or can point me
in the right direction, I wiull be forever in your debt.

Mahalo in advance for your responses,

William Jones

 

[Guest]

William,

There are two things to watch for. The first is the input mask and the
second is the format.

The input mask supports the way data is presented during INPUT but the
format determines how the value is displayed AFTER entry.

I suggest you look at both your text boxes and make sure that they are both
set to use the same FORMAT.

This should take care of your problems.

I think this happens when you manually add a text field and then set it as
your time display field versus using Wizard to add them etc.

HTH

Andre

 

[William Jones]

William,

There are two things to watch for. The first is the input mask and the
second is the format.

The input mask supports the way data is presented during INPUT but the
format determines how the value is displayed AFTER entry.

I suggest you look at both your text boxes and make sure that they are
both set to use the same FORMAT.

This should take care of your problems.

I think this happens when you manually add a text field and then set it
as your time display field versus using Wizard to add them etc.

HTH

Andre

Aloha Andre,

Thanks for the suggestion. I'll have another look at both of the
fields and verify the format.

Mahalo again,

William Jones