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

Dan Waters dwaters at usinternet.com
Tue Jun 20 21:35:22 CDT 2006


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.




More information about the AccessD mailing list