[AccessD] Military Time

Does the field have to be text? I put it as Date/Time & it keeps saying
the value entered is not valid for this field.
 
Thanks for the help.
Virginia
 
*********************
You can use an input mask of 0000;0;"_" to force them to enter the value
in military time and use a validation rule to prevent anything below
0000 or above 2400, but that's as far as it goes.  Since you and Access
can't read minds, you have no way of knowing whether they meant 0100 or
1300 hours, so they are responsible for entering it right.
 
Charlotte Foust