Table Validation in Access 2003

[rookieneedshelp]

I am trying to create a validation rule that one date has to be later than another date. That is,

[DateReturned]>=[DateWritten]

I've learned this can't be done at the field level - that is must be done at the table level. But the instructions I've found say:

1. select the table
2. On the View menu, click Properties
3. Set the ValidationRule property in the Table Properties dialog box to [DateReturned]>=[DateWritten]
4. Close the TAble Properties dialog box, and then save the table.

However, when I go the table's Properties view, there is "ValidationRule". I only have a "General" tab that says:

Type: Table
Description: (box to enter info)

I put the validation rule in this description box, but it does not restrict the date input.

Also, I checked the field types to make sure they are Date/Time.

Can anyone tell me what I'm doing wrong?

 

[PHV]

You must have open the table in design view ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886