validation rule

H

hadeel_albayati

hi
i have a field as date/time and i want to put a
validation rule on tis field so that any entry that is
more than 7 days ahead of the current date will be
refused with a validation text any help will be very much
appreciated thanks in advance
 
A

Allen Browne

1. Open your table in design view.

2. Select the date/time field (named "MyDate" in this example).

3. In the lower pane, set the Validation Rule to:
Is Null Or <= Date() + 7

4. Set the Validation Text to your message, e.g.:
Cannot be more than one week ahead.
 

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

Text Field Validation Rule for Date 1
Validation Rule and color 2
Validation rule for Access 2003 2
conditional validation rules 5
Validation Rule Problem 2
Field Validation Rule to Exclude Ampersand 3
Validation Rule On Form 1
table level validation 7

Top