Charlotte Foust
cfoust at infostatsystems.com
Wed Apr 27 10:31:48 CDT 2005
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 -----Original Message----- From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com] Sent: Wednesday, April 27, 2005 6:30 AM To: accessD at databaseadvisors.com Subject: [AccessD] Military Time I need to format a Time field so they always enter time as 2400, 2330, etc. If they enter 1:00 I want it to change to (1300) the 24 hour time. How do I do that? Virginia -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com