Not allow future dates

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
 
K

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.
 

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

Top