Checking Date Validity

  • Thread starter Thread starter Jim Pockmire
  • Start date Start date
J

Jim Pockmire

Is ther a function to check the validity of a date entered on a form and
print an error message if it is not valid, e.g 2/30/04?
 
If the control on the form is bound to a field of Date type, an error
message will automatically be generated. Otherwise, you can check out the
IsDate() function in VBA.

hth,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation in child form 1
Access 2007 exception on Date Validation rule 0
Validation Rules for a Control on a Form (?) 4
Tricky validations 8
Date as a value to a textbox as a result from another textbox 1
Passport date checker 1
validation code for dates 6
Validation of subform 16

Back
Top