Validation Rule

  • Thread starter Thread starter 1
  • Start date Start date
1

1

I am trying to set up a validation rule in which a date
field can not be populated if two other fields are not
equal to each other.
The date fields input mask is set up as follows
99/99/00;0;_
How would I set up the validation rule-
I have tried [fieldA]=[FieldB]
but I think with the input mask set up as it is when you
delete the figures it still thinks that their is something
populating the date field. Is that possible? Thanks in
advance for your assistance.
 
Hi,



(DateField IS Null) IMP iif(field1 = field2, -1, 0)


if field1 neither field2 can be null, then just

(DateField IS Null) IMP (field1=field2)





Hoping it may help,
Vanderghast, Access MVP
 
Back
Top