Doug Murphy
dw-murphy at cox.net
Tue Jun 20 22:02:42 CDT 2006
Use a input mask to require a certain set of input characters, of the format you require. This is set from the text box mask property. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Tuesday, June 20, 2006 7:35 PM To: AccessD Subject: [AccessD] '6a' or '6p' Are Valid Dates? I was testing a new module and quickly typed '6a' into a date field, expecting to get an error, but no, the table thinks it's a real date! Turns out this will enter 6:00:00 AM 12/30/1899. Of course my customers need this 'quick entry feature'! How can I code to trap this in my form and null the field? Thanks! Dan Waters ProMation <http://www.promationsystems.com/> Systems, Inc. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com