Thanks for your reply and continued help in trying to figure this out. I think what you say about 2007 being stricter than 2010, and 2013 stricter than 2010 probably is quite correct. It's a pity that MS don't tell us these things! The version of 2013 that I am using is via Access 365 which means that it can have automatic updates which could also be a possible problem in the future. For stability I don't like automatic updates as once the dbase is running okay I think it is best to leave it alone and just let it do its work. Hence, I turn the auto update function for Access 2013 (via Windows update) off and try to "manage" those particular product updates. It gets a bit more complicated with Win 8.1 as it likes to download and install updates automatically. I am still trying to understand that, but for now I have this version of Access 2013 EN running on Win 7.
if I create a new text box, and as the control source put =[input-date] and then on the Properties Sheet for format, I format it as a "long date", when asked to Input Parameter Value I input "1/1/2015" (without the quotes of course) I get #Error ....
if I format it as a short date, and still input 1/1/2015 (a short date), I still get #Error ....
if I put =([input-date]) ... add the brackets, it makes no difference, I still get #Error ....
If I leave the format property blank, I still get #Error. In fact if I put anything in the format property, including percent, currency or euro, I get #Error.
In the query the field that selects the records based on the start and end dates has a criteria Between [kwartaal begindatum] And [kwartaal einddatum]. How can you specify the criteria as a date? Certainly the original field [DateServed] that is being used is specified as a Date/Time data type.
Format(CDate([Enter Date]),"dd mmmm yyyy") ... I had to add = before Format, in the control source property, and got #Type! error.
Format("#" & [Enter Date] & "#"),"dd mmmm yyyy") ... similarly, I pasted this into the control source property of the text box, added = before Format, and got #Type! as the error.
Just to add another perspective to the problem, I have another database for accounts. In a report I have a text box with ="Printed: " & Date() ... which on the same computer, same Access 2013 version, works just fine giving a result of "Printed: " and then today's date. If I copy this text box and paste it into the problem database, into the report where I am having difficulty, I first get a input parameter value for "Date" and then #Name? error irrespective of what date I input. Same text box, same text box property settings, but different result.
Is the fundamental problem either that I have the control source as =[input something] or I have something in the problem database not set correctly.... ???