Conditional Expression - Type Mismatch

T

Training Spec.

When I attempt to embed a conditional expression macro into a Form, Access
2007 replies with a ‘type mismatch’ error. I’d like to have a message box
display in a Form to remind the user to enter the correct date (i.e., not
always today’s date, but the actual date the employee received the cell
phone).

I embedded in the ‘on click’ property of the ‘DateAquired’ field, the
following condition: [Forms]![PhonesAndEmployees]![DateAquired]=Date() I know
‘=Date()’ is wrong, but I haven’t figured out the correct expression. As long
as the user enters a date that’s between a month ago and today, that would be
OK. And, no matter what I have tried, Access 2007 says it’s a type mismatch!

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top