I am working on a report and I get a "data type mismatch in criteria expression" error when I go to preview the report. I have no filters set for this report and I have no idea where the error message is coming from. I put breakpoints in front of all of my formatting code, and the compiler goes through the Report_Open code and when it is finished, I get the error message. It doesn't appear to be going through any other code on my report. I've looked through the code and it all seems harmless. Has anyone else had this issue before?
Usually when I get this error message it's because my filter or condition for something or other is looking for a number, but getting a string or visa versa or I'm looking for a string, but not using single quotes.
Usually when I get this error message it's because my filter or condition for something or other is looking for a number, but getting a string or visa versa or I'm looking for a string, but not using single quotes.