RuleValidation property does not work in Access 2007

  • Thread starter Thread starter Dean Slindee
  • Start date Start date
D

Dean Slindee

<=Date() as a RuleValidation works in the .adp development environment, but
does not work after compiled to .ade. The error message generated from the
..ade is "The expression Date you entered in the form control's
ValidationRule property contains the error. The function you entered can't
be used in this expression".

This sounds like VBA is not included as a reference in the compilation.
It's not just one date field, it's occurring on all the date fields on all
the forms, which all have a ValidationRule of "<=Date()". Anyone got any
ideas how to fix this problem?

Thanks in advance,
Dean Slindee
 
I forgot to mention that these RuleValidations worked in the same
application in Office 2003. It is only since recompiling them in Office
2007 that the error message appears.
 
Back
Top