Date and Time Format Need help

[bddewell408]

The field I have is a Date and Time field -
Name - dtmBeginDateandTime
Format - mm/dd/yyyy_hh:nn
Input Mask - mm/dd/yyyy_hh:nn


The Problem when I type 01/01/2005_05:00,
Access converts the entry to 01/01/2005_5:00

I need the entry to remain in true Military Time 05:00

the reason I need this is becase the input mask is necessary to make sure users do not mess up entries, (there have been 23K+ entries into this system, by over 150 users, and I am the only one that knows Access)the users occassionally put in the wrong date or time, and when I go back to make changes, if the time has been shrunk, the input mask will not allow changes, or it states that it is not in an appropriate format and will not let you go forward, to proceed you must type in all of the //_:




I have looked through the FAQ's, printed the entire HELP section from Access, and I am not smart enough to find the answer.

Thanks

 

[SkipVought]

Hi,

Is not 01/01/2005_5:00 military time format. I assumt that 5 PM would display as 01/01/2005_17:00.

I assure you that everything will sort propery, as MS stores these values as NUMBERS, like 38353.20833, which is 01/01/2005_5:00.


Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[bddewell408]

It is not the sorting that is the problem, it is the correction, and copying and pasting that is problematic. I need the input mask mentioned above to guide users to enter correctly, but when I manipulate the data they mess up, if the entry is not in the format of the input mask, the mask disappears and will not let a paste work, also, if I need to modify a entry that the time has been modified to 0:00, the input mask disappears.

Plus it also looks more professional in my opinion when the begin date and times field is the same all the way down the page on a report

 

[bddewell408]

I figured out my problem, it was in the regional setting of the computer, meaning I am going to have to adjust all computers that access this database, luckily only about 10.