Data missed matched type

[grenee]

Good afternoon all.

I have two table:

"Year Range" has field "Year List" of data type Text
"Stat" has field "Year" of data type Text also

The data source for the "Year" field is the "Year List" and this data is access via the lookup wizard.

The problem is that on attempting to sort the list in "Year" a popup message appear with the following "Type missed matched" in expression.

I am sure the data types are all text.


for reference the data in "year list" is:

Year Range Year List 2000-2001 2001-2002 2002-2003 2003-2004 2004-2005 2005-2006 2006-2007 2007-2008 2008-2009 2009-2010 2010-2011 2011-2012 2012-2013 2013-2014 2014-2015

Can this problem be solved?

 

[burrina]

Check the control properties and make sure that any default values are the correct data type. Generally means a mismatch between a numeric, date and text data. Either in the criteria or you're trying to put text data into a numeric field for example.