Not allow future dates

  • Thread starter Thread starter Dan @BCBS
  • Start date Start date
D

Dan @BCBS

When the user enters a date into a text box on a form it should only allow
Todays date or Prior to today.
The form (date text field) is created from the table not a query.
Is there somthing within the form I can do that would Not Allow Future dates?

Thanks
 
Set the Validation Rule for the TextBox to <=Now() by opening the form in
design view, click on menu VIEW - Properties. Click on the text box and
scroll down. Enter the rule and then type in the message to be display if
wrong date is entered in the Validation Text.
 
Back
Top