I have a text box in a report in Access 2013. The database was in Access 2010 and worked fine, and now I have upgraded to Access 2013. The text box has in it
="Report from "&(Format([startdate]),"dd mmmm yyyy")) & " to " & (Format([enddate]),"dd mmmm yyyy"))
the data source is based on a query which asks for the [startdate] and the [enddate]. But when I run the report I get a input question for FORMAT, and if I leave it blank I then get a #TYPE! error. The only thing I can think of is that the Format field for the properties for the text box is blank ... but this didn't seem to be a problem with Access 2010. Does anyone know what is wrong, I need help please?
="Report from "&(Format([startdate]),"dd mmmm yyyy")) & " to " & (Format([enddate]),"dd mmmm yyyy"))
the data source is based on a query which asks for the [startdate] and the [enddate]. But when I run the report I get a input question for FORMAT, and if I leave it blank I then get a #TYPE! error. The only thing I can think of is that the Format field for the properties for the text box is blank ... but this didn't seem to be a problem with Access 2010. Does anyone know what is wrong, I need help please?
Access 2010 v Access 2013 - does FORMAT work differently?
