Date Validation

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

How, with VC coding, would I create validation for a date
field where a past date would not be able to be entered.

I thought something like if Me![datefield] < Date()

Any help would be greatly appreciated.

Paul
 
How, with VC coding, would I create validation for a date
field where a past date would not be able to be entered.

I thought something like if Me![datefield] < Date()

Any help would be greatly appreciated.

Paul
Click to expand...

In the Validation Rule Property of the textbox put...
">=Date()" (without the quotes).

In the Validation Text Property put something to inform the user
like...

"Dates must be today or later." (no quotes)

- Jim
 
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
Date as a value to a textbox as a result from another textbox 1
Validation Rule 3
validation code for dates 6
If then for Field 6
Countif 3
Validation code rule 2
Data Validation 1

Back
Top