Format$ error on database!

[dfuas]

Hi

Happy new year everyone,

I have designed a Access 2000 report which is getting data from a query. However when I run the report is asking to enter a parameter value which is Format$. Running simple the query is all fine but when running the report asks for this parameter and it seems that in does not like my formatting to display dollares values. I have in expression builder the following:
=Format$([Due_Date2],"mmmm yyyy",0,0)

My report is grouped on Dates formatted as month and year but all seems fine.
Does anyone know why is that or had a similar issue?

Thanks

df

 

[boblarson]

Change this:

=Format$([Due_Date2],"mmmm yyyy",0,0)

to this:

=Format([Due_Date2],"mmmm yyyy")