validation rule

  • Thread starter Thread starter hadeel_albayati
  • Start date Start date
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
 
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.
 
Back
Top