I have tried to write a macro in Access 2003 that will result in a message box when the value in a field is $25,000 or more. The field type is set to currency. The field name is IHDAconstruction$. The form name where the macro appears is IHDAProjectsForm. The condition statement in my macro is [Forms]![IHDAProjectsForm]![IHDAconstruction$]>=25000. However, whenever I try to run this macro I get a type mismatch error. I have tried with and without a $ sign in front of the 25000. I have also tried with and without quotes around the 25000. And I still get a type mismatch error. Any help would be greatly appreciated.