#Name? Error

[austinr]

I'm attempting to generate a report in access using the provided wizard. I am trying to sort the report based on a date so that it is subdivided into months/years. The wizard generates the following code:

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

When I preview the report, a "#Name?" error appears everytime. The [Next_Date] field is a valid name... so I'm not sure exactly whats going on. Any help is appreciated. Thanks!

 

[RichO]

Check the 'Name' property of the text box and make sure it is not Next_Date. Call it something like txtNextDate. Often times that is the cause of #Name?.

 

[austinr]

Thanks for the help. I changed the text box name and I no longer recieve the #Name?; however, I now recieve a plain #Error.

When I run the report, it asks me to "Enter a Parameter Value for Format$" Any Ideas on this? All help is appreciated. Thanks in advance.

 

[austinr]

Well, I figured it out. I believe that the name of the text box was the main problem. However, Access for some reason modified the code to read :

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

instead of:
=Format$([Next_Date],"mmmm yyyy",0,0)

This was the source of the #Error. Thanks again for the help.