RuleValidation property does not work in Access 2007

[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

 

[KARL DEWEY]

Not familar with .ade but try using Today() or SysDate instead.

 

[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.

 

[Gina Whipp]

Dean,

Though not familar with .ade, did you try Now()...

....also what is the name of the filed and the data type?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm