[AccessD] '6a' or '6p' Are Valid Dates?

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




More information about the AccessD mailing list