Date Validation

  • Thread starter Thread starter Han
  • Start date Start date
H

Han

I have written a custom module that imports delimited data originating from
a web form. Everything works perfectly EXCEPT when the user enters an
invalid date. For instance, "09/31/2003" is accepted by my web form because
the format (i.e. "mm/dd/yyyy") is correct, but Access throws an error
because there's only 30 days in September. I could write more elaborate
validation code on the web form side, but it would be easier if Access would
accept an invalid date (for later manual correction.)

Is there a way to turn off Access' automatic date validation? If not, are
there any other options (short of writing more extensive date validation
code, whether in my web form or in Access)?

Thanks,
Han
 
|
| Is there a way to turn off Access' automatic date validation? If not, are
| there any other options (short of writing more extensive date validation
| code, whether in my web form or in Access)?
-----------
Hi Han,

If you don't want Access date validation, then don't use a date/time data
type to enter your data. Just use the text datatype.

Hope this helps,
 
Eric,

I had a feeling this was going to be the case. Unfortunately it's not
possible to convert the data field to text so the web form validation will
need to be more robust instead. No biggie really, just more time.

Thanks,
Han
 
Back
Top