Checking Date Validity

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?
 
C

Cheryl Fischer

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,
 

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

MS Project - error message when checking "Critical tasks" 1
Validation in child form 1
Validation Rules for a Control on a Form (?) 4
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
type mismatch error in macro in excel 0
Dcount -Date Criteria - Won´t find it - 0
"Compile error in table level validation expression " after format 0
Access 2007 exception on Date Validation rule 1

Top