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!
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!