Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

strange data type mismatch error

Status
Not open for further replies.

striker73

MIS
Jun 7, 2001
376
US
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.
 
Nevermind... I figured it out. I had set the first grouplevel to a date value, and had selected to group by year. However, when I went back and changed this to a string value, the group by year value was still selected. Took me a while to figure out. How frustrating!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top