Not allow future dates

[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

 

[KARL DEWEY]

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.

 

[Damon Heron]

You can use the validation rule on the text box's properties to specify
<=(Date())
This will catch the discrepancy when you move to a new record.
alternatively, you can test on the textbox exit event to catch it
immediately.

Damon