accessd
max at sherman.org.uk
Wed Apr 27 17:00:15 CDT 2005
Or, going to perhaps as an extreme, two rotating selection boxes (up/down arrows) to circulate hours (from 00 to 23) and a second for mins (from 00 to 59). Wouldn't go there myself, but perhaps an option under some circumstances. At least it would be absolutely accurate especially if populated from the System Time for 'Time now/Time future' entries whereby an 'Enter/Click' would accept the defaults as presented. Max Sherman -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: 27 April 2005 20:56 To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Military Time This would mean extra work, but if you think the users will make mistakes you could always let them enter regular time, mark it as am or pm and convert it internally to military time. Susan H. However, you can use the Short Time format, which is 17:00. Then all you need do on a form is use "00:00" for the format string. Access short time won't let you enter 2400, which has to be converted to 0000 hours in the form. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com